Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

Expressing Your Work in Scientific Notation

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