Answers for "oracle convert to number"

oracle to_number

TO_NUMBER('1210.73', '9999.99')
Result: 1210.73

TO_NUMBER('546', '999')
Result: 546

TO_NUMBER('23', '99')
Result: 23

Posted by: Guest on December-20-2020

oracle convert string number

SELECT to_number('1') FROM DUAL;

Posted by: Guest on April-07-2021

Code answers related to "oracle convert to number"