Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column format for Describe

Adhika WOct 20 2008 — edited May 8 2009
Hi guys,

I got a small question here.
The question is regarding the column formating in SQL prompt.

basically we can use DESCRIBE <table_name> to see the columns existed in a table.
the column headers appear are "Name", "Null", and "Type"

if you don't do any linesize and pagesize setting, the result of the describe is good enough, but the thing is when you set both linesize and pagesize to 1000, in linux you'll get a really screwed result of that DESCRIBE syntax.
in windows of course this might not happen if you set the screen buffer size to 1000 as well.

so, come to the real question:
How can I format the column header for DESCRIBE syntax?

Regards,
Adhika
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2009
Added on Oct 20 2008
8 comments
1,201 views