Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
TO_NUMBER(expr [, fmt [,'nlsparam']])TO_NUMBER(<binary_float | binary_double | number>,'<hex mask>')RETURN<binary_float | binary_double | number>;-- convert character string data into a number:UPDATE employees SET salary = salary +TO_NUMBER('100.00','9G999D99')WHERE last_name ='Perkins';-- Note the 'nlsparam' argument in this functionSELECTTO_NUMBER('-AusDollars100','L9G999D99',' NLS_NUMERIC_CHARACTERS = '',.''
NLS_CURRENCY = ''AusDollars''
-----------100-- convert a HEX to FLOATSELECTTO_NUMBER('0A','XX')FROM dual;SELECTTO_NUMBER('1F','XX')FROM dual;-- convert a HEX to DECIMALSELECTTO_NUMBER(100000,'XXXXXXXX')FROM dual;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.