Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Generating Blank Lines in SQLPlus
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 - 11:19:03 CST