SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

spool file with just the data

116460Jan 22 2003 — edited Jan 23 2003

Hi,
I have a sql query that I'm spooling to a file. I have set echo off, heading off, feedback off, verify off. The spool file is exactly what I want except for the SQL prompt and the actual query. It looks like this:

SQL> "select statement;"
data data
data data
data data
data data
SQL>

What parameter do I set so that the

SQL> "select statement"

doesn't appear in the spooled file at the top, and

SQL>

doesn't appear at the bottom?
I need data only.

Thanks
-Bob

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2003

Added on Jan 22 2003

6 comments

428 views