Re: Generating Blank Lines in SQLPlus

From: Kirk W. Conrad <kwconrad_at_mdanderson.org>
Date: Wed, 10 Jan 2001 09:56:08 -0600
Message-ID: <93i0mr$912$1@oac2.hsc.uth.tmc.edu>

Thank you all for your suggestions. They work well.

Kirk

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 Wed Jan 10 2001 - 09:56:08 CST