Re: How to do linefeed in SQL?

In sql*plus you can use newline option of column like suggested or you could concatenate a newline character to your sql column. This is sometimes a useful way to accomplish the same task.

select column_name||chr(10), column_name2||chr(10)   from some_table;

Also look up the column command options fold_after and fold_before, but these affect the way the headings print and sometimes you only want to manupulate the row output.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Sat Feb 22 1997 - 00:00:00 CET