REPOST: 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

• WAS CANCELLED BY =======: From: Sybrand Bakker <postbus_at_sybrandb.demon.nl> Control: cancel <8vk75u4eveu3qv0hr1ifned0nu82jkp11f_at_4ax.com> Subject: cmsg cancel <8vk75u4eveu3qv0hr1ifned0nu82jkp11f_at_4ax.com> Date: Sun, 27 Jan 2002 22:58:56 GMT Message-ID: <cancel.8vk75u4eveu3qv0hr1ifned0nu82jkp11f_at_4ax.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!news-han1.dfn.de!news-kar1.dfn.de!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!peer.news.opaltelecom.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40715923

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sun Jan 27 2002 - 04:19:50 CST