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:

select char(identifier)
  from MyTable;

SQL Error: ORA-00936: missing expression
00936. 00000 -  "missing expression"

Open in new window


How can I see all the digits in the column?

Thanks!
DaveSlash
LVL 18
Dave FordSoftware Developer / Database AdministratorAsked:
Who is Participating?
 
sdstuberCommented:
to_char(identifier)
0
 
slightwv (䄆 Netminder) Commented:
Another possibility in sqlplus:
set numwidth 12

Then you don't have to worry about individual columns.
0
 
Dave FordSoftware Developer / Database AdministratorAuthor Commented:
Perfect! Thanks very much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.