Home » SQL & PL/SQL » Client Tools » Spool Output and Rollback. (Oracle 10g, AIX)
Spool Output and Rollback. [message #528622] Wed, 26 October 2011 02:21 Go to next message
bobberty
Messages: 5
Registered: October 2011
Junior Member
Hi, i am a complete novice and would appreciate some advice, i need to do the following via the sql plus command prompt :

1. Execute a large ".pls" script file which does various inserts and updates to a table.

2. Spool the output of "select * from updatedtable;" to a text file to see the changes made.

3. Rollback all the updates and inserts in the script.

Many thanks.
Re: Spool Output and Rollback. [message #528627 is a reply to message #528622] Wed, 26 October 2011 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
start x.pls
spool x.lst
select * from updatedtable;
spool off
rollback;


SQL*Plus User's Guide and Reference and now you are no more a novice.

Regards
Michel
Re: Spool Output and Rollback. [message #528630 is a reply to message #528627] Wed, 26 October 2011 02:50 Go to previous message
bobberty
Messages: 5
Registered: October 2011
Junior Member
Many thanks Michel, i'll give that a try.
Previous Topic: Spool in UTF8 not always works
Next Topic: if you liked classic SQL Plus , what now?
Goto Forum:
  


Current Time: Sat Feb 24 07:09:23 CST 2018

Total time taken to generate the page: 0.01574 seconds