Mega Code Archive
Categories
/
Oracle PLSQL
/
Data Type
To_char( 111, 099 99 )
SQL> SQL> select to_char( 111, '099.99' ) "NUMBER" from dual; NUMBER ------- 111.00 SQL>