Mega Code Archive

 

Categories / Oracle PLSQL / Conversion Functions

 

Converting a Character Formatted as Currency to an Integer Value

SQL> SQL> DECLARE   2       v_Convert_Number VARCHAR2(20) := '$119,252.75';   3       v_Hold_Number NUMBER ;   4  BEGIN   5       v_Hold_Number := TO_Number(v_Convert_Number,'$999,999,999.99');   6       DBMS_OUTPUT.PUT_LINE('The converted number is: ' || v_Hold_Number);   7       DBMS_OUTPUT.PUT_LINE('Your commission at 6% is: ' ||   8                            (v_Hold_Number*.06));   9  END;  10  / The converted number is: 119252.75 Your commission at 6% is: 7155.165 PL/SQL procedure successfully completed. SQL> SQL> --