Appending data in a file by sql* plus spool command using Oracle 9i

I am trying to append data to file A_1.  The syntax below is not working.  Any help would be appreciated.  Thanks

 spool C:\A_1.txt
SELECT
*
FROM
a_1 A
/
spool OFF;

spool C:\A_1.txt append
SELECT
*
FROM
a_2 A
/
spool OFF;
doot_dootAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I believe append is a 10g new feature.

Just don't spool off.

spool C:\A_1.txt
SELECT
*
FROM
a_1 A
/
SELECT
*
FROM
a_2 A
/
spool OFF;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.