oracle varchar to number

Question

How do i convert a oracle varchar value to number  eg  table - exception exception value 555 where exception value is a varchar type   I would like to test the value of exception value column   select   from exception where exception value   105 instead of select   from exception where exception value    105

User · Answer

You have to use the TO NUMBER function   select   from exception where exception value   to number  105

User · Answer

If you want formated number then use   SELECT TO CHAR number   fmt      FROM DUAL   SELECT TO CHAR  123   999 99     FROM DUAL    Result 123 00

User · Answer

select to number exception value  from exception where to number exception value    105

User · Answer

Since the column is of type VARCHAR  you should convert the input parameter to a string rather than converting the column value to a number   select   from exception where exception value   to char 105

User · Answer

I have tested the suggested solutions  they should all work   select   from dual where  105   to number  105         delivers one dummy row  select   from dual where  10   to number  105         empty result  select   from dual where   105    to char 105        delivers one dummy row  select   from dual where   105    to char 10        empty result

[oracle] oracle varchar to number

Examples related to oracle

Examples related to numbers

Examples related to varchar