Link to home
Start Free TrialLog in
Avatar of Member_2_2484401
Member_2_2484401Flag for United States of America

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:

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
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Another possibility in sqlplus:
set numwidth 12

Then you don't have to worry about individual columns.
Avatar of Member_2_2484401

ASKER

Perfect! Thanks very much!