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:
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:
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
How can I see all the digits in the column?