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> --
Related examples in the same category