I've inhertited a table that contains a NUMBER(12) column. Where I query the data, I get the following:
IDENTIFIER
----------
9.5E+11
I'd like to see all the significant digits in the number ... solely for "visual purposes". In DB2, I would just put a CHAR or VARCHAR around the column-name to see the whole column. But, when I try that in Oracle, I get this:
set numwidth 12
Then you don't have to worry about individual columns.