Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPlus column widths

Re: SQLPlus column widths

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 27 Jan 2002 11:19:50 +0100
Message-ID: <8vk75u4eveu3qv0hr1ifned0nu82jkp11f@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 - 04:19:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US