Member_2_2484401
asked on
display all digits in a NUMBER(12) column
Greetings, experts!
I have another "rookie" Oracle question.
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:
How can I see all the digits in the column?
Thanks!
DaveSlash
I have another "rookie" Oracle question.
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:
select char(identifier)
from MyTable;
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
How can I see all the digits in the column?
Thanks!
DaveSlash
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thanks very much!
set numwidth 12
Then you don't have to worry about individual columns.