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 with formatted output?

Re: sqlplus with formatted output?

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Fri, 11 Jan 2002 15:02:41 -0600
Message-ID: <reku3ugp016c0qauopeg4d2qt1e9bad5cd@4ax.com>

No Need...

do this

set linesize 120
set pause off
set pagesize 0
column id format a4
column test1 format a10
column test2 format a10
column test2 format a10
blah..blah..blah...

Then
you should get:
id test1 test2 blah
---- ---------- ---------- ----------

1    bla         bla         bla
2    super    nice       bad


Why:
the column definitions set the size of the column and, by extension, the # of dashes under the column name it should format ok..just change the column specs to the max you need...

"Andre Vaupel" <avaupel_at_web.de> wrote:

>Hi!
>
>Thanks for your answer :-)
>
>
>I did and found out to set linsize 200 or more in example and wrap on or
>off, depends
>on the comlumns.....then the output seems be better...but no really readable
>:-/
>I gues i build a simple script in php and pass the output through a
>website...
>
>But anyway thanks a lot for your help!
>
>
>Andre
>
>
>
>
>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag
>news:jciu3usi7kvd2u7q9t3492j4ll2d4dnd4g_at_4ax.com...
>> On Fri, 11 Jan 2002 19:54:29 GMT, "Andre Vaupel" <avaupel_at_web.de>
>> wrote:
>>
>> >Hi!
>> >
>> >
>> >IZm trying to get a good formatted output like this with sqlplus:
>> >
>> >id test1 test2 test3 .....
>> >--------------------------------
>> >1 bla bla bla
>> >2 super nice bad
>> >
>> >
>> >but what i get is usual like this:
>> >
>> >
>> >
>> >id
>>
>>---------------------------------------------------------------------------
>-
>> >1
>> >bla --------------------------------------------------------2
>> >super------------------------
>> >2
>> >
>> >
>> >ItZs just an example.....
>> >
>> >Thanks a lot for any ideas!
>> >
>> >
>> >
>> >Andre
>> >
>> >
>> >
>>
>> Study the sq*plus manual carefully, especially the column command and
>> the set linesize command
>>
>> Hth
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>> To reply remove -verwijderdit from my e-mail address
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Jan 11 2002 - 15:02:41 CST

Original text of this message

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