## "Numeric" column TYPE casting problems


   SELECT . . .
   FROM   EMP
   WHERE  EMP_NO = '123';

## This statement will actually be processed as:

   SELECT . . .
   FROM   EMP
   WHERE  EMP_NO = TO_NUMBER('123');



   SELECT . . .
   FROM   EMP
   WHERE  EMP_TYPE = 123;


## This statement will actually be processed as:

   SELECT . . .
   FROM   EMP
   WHERE  TO_NUMBER(EMP_TYPE) = 123;