REPOST: Re: SQLPlus column widths

From: Fernão Magalhaes <barameda_at_h.o.t.m.a.i.l.com>
Date: Sun, 27 Jan 2002 13:49:52 -0800
Message-ID: <6$--$%%%_$_$__$%-$@news.noc.cabal.int>

The SQL+ command to format columns is:

COLUMN column_name FORMAT format

It only accepts a constant value, but not an expression. You need to query the datatype and column heading length, then decide which value to use.

--Fernão
DBA wannabe

"Christian Maslen" <cmaslen_at_nospam.bigpond.net.au> wrote in message news:xJN48.14478$Ni2.74908_at_news-server.bigpond.net.au... 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.

WAS CANCELLED BY =======: From: "Fernão Magalhaes" <barameda_at_h.o.t.m.a.i.l.com> Control: cancel <eDvUUs4pBHA.584_at_cpimsnntpa03> Subject: cmsg cancel <eDvUUs4pBHA.584_at_cpimsnntpa03> Date: Mon, 28 Jan 2002 00:34:31 GMT Message-ID: <cancel.eDvUUs4pBHA.584_at_cpimsnntpa03> 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!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40715880

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 - 15:49:52 CST