Monday, November 23, 2009

Formatting SQL*PLUS output

SQL> select max(account_code_n) from mastertable;

account_code_n
-----------------
2.000E+09

SQL> column account_code_n format 9999999999999

SQL> select max(account_code_n) from mastertable;

account_code_n
-----------------
2908006098712

No comments: