Q:Spooling SQL*Plus output without newlines between rows
From: Mike Perkins <Mike.Perkins_at_DaytonOH.ATTGIS.COM>
Date: 1995/11/17
Message-ID: <DI78q0.8Ds_at_corsair.daytonoh.attgis.com>#1/1
Date: 1995/11/17
Message-ID: <DI78q0.8Ds_at_corsair.daytonoh.attgis.com>#1/1
How can I suppress the newline between rows returned with a select statement in sqlplus.
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....
Michael C. Perkins
AT&T Global Information Solutions
"Dave is cool, the Cup is on his show, ergo hockey is cool !" - David Letterman Received on Fri Nov 17 1995 - 00:00:00 CET