OraFAQ Forum: Client Tools » Spool Output and Rollback.

Home » Other » Client Tools » Spool Output and Rollback. (Oracle 10g, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Spool Output and Rollback. [message #528622]

Wed, 26 October 2011 02:21

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.

Report message to a moderator

Re: Spool Output and Rollback. [message #528627 is a reply to message #528622]

Wed, 26 October 2011 02:47

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Spool Output and Rollback. [message #528630 is a reply to message #528627]

Wed, 26 October 2011 02:50

bobberty
Messages: 5
Registered: October 2011

Junior Member

Many thanks Michel, i'll give that a try.

Report message to a moderator

Previous Topic:	Spool in UTF8 not always works
Next Topic:	if you liked classic SQL Plus , what now?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:16:07 CST 2025