Avatar of Member_2_2484401
Member_2_2484401
Flag 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
Oracle Database

Avatar of undefined
Last Comment
Member_2_2484401

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Sean Stuber

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
slightwv (䄆 Netminder)

Another possibility in sqlplus:
set numwidth 12

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

ASKER
Perfect! Thanks very much!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck