formated output with sql-plus

From: Olaf Naumann <ONaumann_at_netcologne.de>
Date: Fri, 11 Feb 2000 13:23:33 +0100
Message-ID: <8815a8$9au$1@news.netcologne.de>

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 Fri Feb 11 2000 - 06:23:33 CST