Converting number to character formatted as a numeric string : Data Type Convert « PL SQL « Oracle PL / SQL






Converting number to character formatted as a numeric string



SQL> -- Converting number to character formatted as a numeric string.
SQL> DECLARE
  2       myNumber NUMBER := 90210;
  3       myChar VARCHAR2(21) ;
  4  BEGIN
  5       myChar := TO_CHAR(myNumber,'0000000000');
  6       DBMS_OUTPUT.PUT_LINE('The employee ID is: ' || myChar);
  7  END;
  8  /
The employee ID is:  0000090210

PL/SQL procedure successfully completed.

SQL>
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.Convert char to number
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()