Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> REPOST: Sqlplus vertical output

REPOST: Sqlplus vertical output

From: Sauronatmordor <csaba_at_securities.com>
Date: 25 Jan 2002 08:42:54 -0800
Message-ID: <1$--$%%%_$_$_%$-$$@news.noc.cabal.int>


Oracle Gurus...

Is there any way to move away from the usual horizontal output of sqlplus and get it to output records vertically? Like instead of

selec a,b,c from mytable;

a b c
- - -

5 6 7

I want:

a: 5 
b: 6
c: 7

Reading through the formatting docs doesn't give me any idea. Thanks a lot.
Csaba

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 10:42:54 CST

Original text of this message

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