Converting a Character Formatted as Currency to an Integer Value : CHAR Type Convert « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL> set serveroutput on
SQL> set echo on
SQL>
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.








21.3.CHAR Type Convert
21.3.1.Convert VARCHAR to Number implicitly
21.3.2.Convert Number to VARCHAR implicitly
21.3.3.Converting a Character to an Integer Value
21.3.4.Converting a Character Formatted as Currency to an Integer Value
21.3.5.Converting VARCHAR2 Percentage Data to a Decimal Equivalent