Column format for Describe
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