Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: formated output with sql-plus
The least headache I would assume when taking awk or nawk. For NT you
can get them at www.cygwin.com
General idea:
Prepare a conventional spool file, one line per row. Run it through awk with a script doing your reformatting.
Martin
Olaf Naumann wrote:
>
> i have the following problem:
>
> i would like select date from an oracle database but each column must be
> printed as a line. after each complete record i need a special constant
> text. examle:
>
> i have a table with the columns col1, col2, col3. the table content is:
>
> col1 | col2 | col3
> aaa 111 xxx
> bbb 222 zzz
>
> the ouput shoul look like:
> col1=aaa
> col2=111
> col3=xxx
> [EOR]
> col1=bbb
> col2=222
> col3=zzz
> [EOR]
>
> any ideas wellcome.
>
> olaf naumann
Received on Sun Feb 13 2000 - 14:25:14 CST