Oracle PL/SQL Tutorial/PL SQL Data Types/Number Format
Expressing in Scientific Notation
<source lang="sql">
SQL> SQL> set serveroutput on SQL> set echo on SQL> 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></source>