How do I convert an exponential number (NUMBER) to string (VARCHAR) but which is expressed equal to?
Example:
SQL> SELECT TO_CHAR (NUMERO) NUMCONVERT
2 FROM (SELECT 3E4 NUMERO FROM DUAL);
NUMCONVERT
----------------------------------------
30000
How to return '3E4' ??