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: Andre Vaupel <avaupel_at_web.de>
Date: Fri, 11 Jan 2002 20:38:32 GMT
Message-ID: <c3I%7.47766$474.477906@news.easynews.com>


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

Original text of this message

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