to_number('123') : TO_Number « Conversion Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Conversion Functions
3. TO_Number

to_number('123')

 

SQL>
SQL>
SQL> select 123
  2  ,      to_char(123)
  3  ,      to_char(123,'$09999.99')
  4  ,      to_number('123')
  5  from   dual;

       123 TO_ TO_CHAR(12 TO_NUMBER('123')
---------- --- ---------- ----------------
       123 123  $00123.00              123

SQL>

   
  

Related examples in the same category