Re: SQLPlus column widths

I did read the manual. The column command takes a column name and a width - as I understand it I need to issue this command for every column I come across that has a truncated title (this gets tedious after a while). I also read that number columns are displayed as I require. I.e. the greater width of the column name or the length numwidth variable (this is easy to set once).

My question was how this could be done in general (maybe supplying an expression???), as the manual didn't mention it, and I couldn't get it to work by spending the time trying. I did think of generating a list of column commands by querying the catalogs, but it seemed like a very indirect way of achieving a very simple requirement.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:8vk75u4eveu3qv0hr1ifned0nu82jkp11f_at_4ax.com...
> On Sun, 27 Jan 2002 07:10:21 GMT, "Christian Maslen"
> <cmaslen_at_nospam.bigpond.net.au> wrote:
>
> >Is there a SQLPlus command that will make the display of a column the
> >greater of either the datatype or the column name?
> >
> >And can this be applied to every column instead of having to name the
> >columns explicitly, before typing your select statement?
> >
> >Thanks in advance,
> >Christian.
> >
> Please check out the sql*plus reference manual, the column command.
> Also checkout numwidth
>
> Obviously this would have been much faster than posting to the
> newsgroup.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Jan 27 2002 - 21:06:36 CST