Re: Generating Blank Lines in SQLPlus

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 9 Jan 2001 20:07:44 +0100
Message-ID: <93fo35$9qktn$4@ID-62141.news.dfncis.de>

prompt ''

will do.

Hth,

Sybrand Bakker, Oracle DBA

"Kirk W. Conrad" <kwconrad_at_mdanderson.org> wrote in message news:93fho8$35n$1_at_oac2.hsc.uth.tmc.edu...
> I'm trying to use SQLPlus to extract database information from dba_...
> tables and create some scripts to run in unix using the spool statement.
I
> need to get some blank lines in the scripts. Is there any way to do a
blank
> line in SQLPlus? I can return a single line with "no rows selected" by
using
> select * from dual where 1=2. If I could just get the "no rows selected"
to
> not print I'd be okay. Basically, I need to do carraige return/line
feeds.
> Any ideas?
>
> Thanks.
> Kirk
>
>
Received on Tue Jan 09 2001 - 13:07:44 CST