Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Generating Blank Lines in SQLPlus

Generating Blank Lines in SQLPlus

From: Kirk W. Conrad <kwconrad_at_mdanderson.org>
Date: Tue, 9 Jan 2001 11:19:03 -0600
Message-ID: <93fho8$35n$1@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 - 11:19:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US