Mega Code Archive
Categories
/
Oracle PLSQL
/
Data Type
TO_CHAR(12345 67, 99999 99EEEE)
SQL> SQL> SQL> SELECT TO_CHAR(12345.67, '99999.99EEEE') FROM dual; TO_CHAR(12 ---------- 1.23E+04 SQL> SQL>