OraFAQ Forum: Server Administration » Columns not displayed

Home » RDBMS Server » Server Administration » Columns not displayed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Columns not displayed [message #371518]

Wed, 01 November 2000 18:32

arun
Messages: 67
Registered: January 2000

Member

I have run a select * from Oracle SQL Plus. However the table has 7 columns of which only 5 are displayed. I have tried turning the wrap option off and set the line size from 132 to 240 but the result is the same.
I look forward to some help from the gurus.
Thanks

Report message to a moderator

Re: Columns not displayed [message #371522 is a reply to message #371518]

Wed, 01 November 2000 20:52

Cliff
Messages: 6
Registered: October 2000

Junior Member

Write the following commands before exec the query:

"COLUMN column_name noprint"

Advice: you should read the sqlplus help carefully

Report message to a moderator

Re: Columns not displayed [message #371524 is a reply to message #371522]

Thu, 02 November 2000 09:27

arun
Messages: 67
Registered: January 2000

Member

When the commands COLUMN column_name noprint is given, the only difference is that it is not displayed on the screen ,but when spooled only the first four columns are captured. I checked the help in SQL plus, but could not find any which tells you how to get all the columns. However I do appreciate your help.

Report message to a moderator