Re: sqlplus with formatted output?

Hey!

Thats great...seems thats the right way!!!! I did never the option " column id format a4"...

Thanks a lot :-))))) !!!!

Andre

"TurkBear" <jgreco1_at_mn.rr.com> schrieb im Newsbeitrag news:reku3ugp016c0qauopeg4d2qt1e9bad5cd_at_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:30:22 CST