Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus with formatted output?
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
![]() |
![]() |