Mega Code Archive
Categories
/
Oracle PLSQL Tutorial
/
Conversion Functions
TO_CHAR(12345 67, 99999V99)
SQL> Select TO_CHAR(12345.67, '99999V99') from dual; TO_CHAR( -------- 1234567