Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Converts the string 970 13 to a number using TO_NUMBER()

SQL> SQL> --------------------------------------------------------------------------------------- SQL> SQL> -- Converts the string 970.13 to a number using TO_NUMBER(): SQL> SQL> SELECT TO_NUMBER('970.13') FROM dual; TO_NUMBER('970.13') -------------------              970.13 SQL>