Mega Code Archive

 

Categories / Oracle PLSQL / Conversion Functions

 

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> --