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/save append?

537728Mar 16 2007 — edited Mar 20 2007
Hi, I need some help with a simple task.
I am running every night this script:

spool c:\DS01\datalog.txt;
SELECT * FROM EPTABLA_01;
spool off;


easy one, right?
The problem is, I don't want the file to be replaced each time I execute the query, I just want to the data of every night in the same txt. I am trying it with "save append" command, but it just write the query itself and not the content of the table.

So the question is, how do I save the content of the table in a file without deleting the previous content that this file is holding?
help please
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2007
Added on Mar 16 2007
8 comments
6,885 views