Oracle Convert to number
The Oracle docs note the syntax for the Oracle to number conversion
function as follows:
TO_NUMBER(text-exp, [fmt,] [nlsparams]
The Oracle to number conversion function is used to convert
data of type char or varchar2 to type number. The
Oracle to number conversion function accepts a single
parameter. For example,
to_number ('34000')
would return
34000
Like the to_char() and to_date() functions, the
Oracle to number conversion function also accepts a format
model as the second parameter. For example:
to_number ('34000', '$99,999.99')
would return
$34,000.00
Find more information on the Oracle to number conversion
function at the links below:
