sqlplus one column output question

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 - 10:22:15 CDT