Spool Output and Rollback. [message #528622] |
Wed, 26 October 2011 02:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1f688f26b934eb48fb5fc8f2940ccb55?s=64&d=mm&r=g) |
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.
|
|
|
|
|