asked on

How can I rollback insert statements after commit in oracle?

I am oracle newbie, I have tried to search online with no success.Can anyone please tell me how can I create a rollback script after committing Insert statements in oracle Database?

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Pawan Kumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Frank Danny

ASKER

Thank you @sdstuber and @slightwv,i hv not commited yet those insert statements,i simply want to create a backup before running my script in prod environment.Is matching delete statement work?i hv only four insert statements,

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial