Expressing in Scientific Notation : Number Format « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. Number Format

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>