Skip to Main Content

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 without sql query

583525Jun 26 2007 — edited Jun 27 2007
Hi,
I want to spool the results of a query to a file.
I don't want to see the query or anything else other than the results in the file.

How do I suppress that information.
I've been trying
SET ECHO OFF
SET FEEDBACK OFF
SPOOL /home/abc/file.txt
SELECT user from DUAL;
SPOOL OFF;
SET ECHO ON
SET FEEDBACK ON

But I guess there is some command I am missing.

Any help would be appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2007
Added on Jun 26 2007
9 comments
5,525 views