select statement -format longer record result set!! HELP PLEASE!!

#1 (**permalink**) 02-27-2008, 03:29 AM

I have a select statement that has more than 20 fields and result set
record length is more than 300 characters for each row. How do I modify
the sql such that the output is formatted for single page view, and
include new lines after the fields, as necessary. Certain fields should
be on its own line.

Thanks for the help.

#2 (**permalink**) 02-27-2008, 03:29 AM

"select col1 || chr(10) || col2 || chr(10) || col3 from table1 "

would return

col1
col2
col3

for each row selected.

#3 (**permalink**) 02-27-2008, 03:29 AM

Thanks, I appreciate your timely help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode