Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPlus column widths
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 - 04:19:50 CST