Hi,
if you abandon on the additional information like <row1>, column1 etc. you may try the following:
column "Newline Character" noprint new_value newline_char
select chr(10) "Newline Character" from dual;
set colsep "&newline_char"
undefine newline_char
column "Newline Character" clear
set recsep each
set recsepchar "-"
Now the columns of each selected row will be written as one column per line and a line of "-" is used
as separator between rows.
regards
kf
Is it possible to align vertically the columns displayed in sql*plus like under SQLite by using .mode line or in MySQL by ending the query with \G?...something like:<row1>column1: 1.23column2: "the value"column3: 0<row2>column1: 2.55column2: "another val"column3: 1