Re: Q:Spooling SQL*Plus output without newlines between rows

Try 'SET RECSEP OFF' before entering the query.

To get things back to normal (default) 'SET RECSEP WRAPPED'

Rob Verlander

Mike Perkins <Mike.Perkins_at_DaytonOH.ATTGIS.COM> wrote:
>
>How can I suppress the newline between rows returned with a select statement
>in sqlplus.
>
>I want to do something like:
>
>SELECT employee||', '
>FROM employee_tbl
>
>and get an output that looks like this:
>
>mike, steve, barry, al, grumpy, sneezy, doc, .....
>
>
>rather than:
>
>mike,
>steve,
>barry,
>etc....
>
>
Received on Tue Nov 21 1995 - 00:00:00 CET