Re: Generating Blank Lines in SQLPlus

"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?

   Use PROMPT command in SQL*Plus

Valery Yourinsky

-- 
Oracle8 Certified DBA