Convert char to number : Data Type Convert « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Data Type Convert

Convert char to number

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

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Convert char to date: TO_DATE('January 01, 2000','Month DD, YYYY')
2.Convert number to char
3.Converting number to character formatted as a numeric string
4.Converting VARCHAR2 percentage data to a decimal equivalent
5.Convert date to char, and char to date with various formats
6.Convert char to number and number to char with various formats
7.Data implicit conversion examples: from char to number
8.Data implicit conversion examples: from char to date
9.Expressing your work in scientific notation with TO_CHAR()