Re: sqlplus one column output question

From: Tom Best <tom.best_at_bentley.com>
Date: Thu, 27 May 2004 12:53:08 -0400
Message-ID: <c955ak$k73$1@news.bentley.com>

See the PRINT_TABLE proc by Tom Kyte:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1035431863958

Tom Best

"Andrew" <myfam_at_surfeu.fi> wrote in message news:c5826e91.0405270722.655749ab_at_posting.google.com...
> Hi,
> I am relatively new user of sqlplus and oracle.
> I am wondering if it is possible to format the output
>
> SELECT * FROM table ORDER BY columnX;
>
> so that it will be spooled (without wrapping) as
>
> COLUMN1=val1.1
> COLUMN2=val1.2
> ...
> COLUMNN=val1.N
>
> COLUMN1=val2.1
> COLUMN2=val2.2
> ...
> COLUMNN=val2.N
>
> ................................
>
> COLUMN1=valM.1
> COLUMN2=valM.2
> ...
> COLUMNN=valN.N
>
> I am suspecting this is not possible with just sqlplus formatting
instructions.
> Is there a simple pl/sql script which would perform such output from
tables?
>
> Regards,
> Andrew
Received on Thu May 27 2004 - 11:53:08 CDT