Converting VARCHAR2 Percentage Data to a Decimal Equivalent : TO_Number « Conversion Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Conversion Functions
  3. TO_Number

Converting VARCHAR2 Percentage Data to a Decimal Equivalent

  
SQL>
SQL> DECLARE
  2       v_Convert_Number VARCHAR2(20) := '33.33';
  3       v_Hold_Number NUMBER ;
  4  BEGIN
  5       v_Hold_Number := TO_Number(v_Convert_Number,'999.999999');
  6       DBMS_OUTPUT.PUT_LINE('The converted number is: ' || v_Hold_Number);
  7       DBMS_OUTPUT.PUT_LINE('Your decimal equivalent is: ' ||
  8                            (v_Hold_Number/100));
  9  END;
 10  /
The converted number is: 33.33
Your decimal equivalent is: .3333

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> --








Related examples in the same category

1.Converting a Character to an Integer Value
2.Converting a Character Formatted as Currency to an Integer Value
3.Errors with the Format Mask
4.to_number('123')