Formatting Select output

Hi!

I need to display the output of a table in a format where I have all the field names and values as

field1: <value1>
field2: <value2>
:
:
:

I think this might be possible using some output processing capabilities in ORACLE. I need to find a way to create a newline after each field output so that the value is pushed to the next line as above.
I could set the column length to the page width but I am not sure how to do that and am looking for a more sophisticated way as I cannot say that the page width will always be the same for all users.

Any help will be appreciated.

thanks
**Snehal Patel**

PS: I thank all the people who replied so promptly to my previous questions. Received on Sun May 15 1994 - 22:21:01 CEST