oracle_dba
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment