Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. TO_CHAR(12345 67, 99999V99)
SQL>
SQL>
SQL> SELECT TO_CHAR(12345.67, '99999V99') FROM dual;
TO_CHAR(
--------
 1234567
SQL>
SQL>