SQL> -- Expressing your work in scientific notation.
SQL> DECLARE
2 myNumber NUMBER := 90210;
3 myChar VARCHAR2(21) ;
4 BEGIN
5 myChar := TO_CHAR(myNumber,'9.99EEEE');
6 DBMS_OUTPUT.PUT_LINE('The Scientific Notation is: ' || myChar);
7 END;
8 /
The Scientific Notation is: 9.02E+04
PL/SQL procedure successfully completed.
SQL>