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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 11 Jan 2002 21:23:30 +0100
Message-ID: <jciu3usi7kvd2u7q9t3492j4ll2d4dnd4g@4ax.com>


On Fri, 11 Jan 2002 19:54:29 GMT, "Andre Vaupel" <avaupel_at_web.de> wrote:

>Hi!
>
>
>IŽm 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
>
>
>ItŽs 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:23:30 CST

Original text of this message

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