Answers for "oracle convert varchar 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 sql varchar to number

SELECT to_number('1') FROM DUAL;

Posted by: Guest on April-07-2021

Code answers related to "oracle convert varchar to number"