Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus with formatted output?
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
Received on Fri Jan 11 2002 - 14:38:32 CST