How to create rollback statements automatically
Hi People
I need to write a script which can generate the ROLLBACK statements for the IMPLEMENTATIONS(Create table, view, index, package, trigger etc Insert table, update table, delete table, Grant etc - which means that implementation could be anything) .
Is there is anyway that I can create or generate corresponding ROLLBACK statements for each statement that i exceute on my database?
Basically there could be a list of operations that I will do and later on I would like to bring the database back to where it was prior to the implementation.