Re: Generating Blank Lines in SQLPlus

You can write

select ' ' from dual where 1=1;

in ' ' you can put code for LF or CR.
set pages 0 - must be

"Kirk W. Conrad" wrote:

> 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 - 01:37:37 CST