We help IT Professionals succeed at work.

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

doot_doot
doot_doot asked
on
1,602 Views
Last Modified: 2012-05-11
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;
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.