Oracle PL/SQL Tutorial/PL SQL Data Types/Number Format

Материал из SQL эксперт
Перейти к: навигация, поиск

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>