Trending DB2/SQL Discussions

Can we rollback a committed transaction in Transact SQL? How?‎

This might not be possible as a part of DML directly, but can we use SQL logs or some filters or anything in the tables to achieve this?‎

Answers:

10

Followers:

4

Views:

2518

Vote Count:

1

Is it possible to define a cursor with in a cursor or anonymous cursor with in a cursor in pl/sql? if possible then how to implements?‎

Answers:

1

Followers:

0

Views:

111

Vote Count:

0

 

Answer added by  Mohamed Gad, Support Developer, Simpl Group
10 years ago

As mentioned earlier, you cannot rollback a transaction that is committed. However, you may use transaction logs to restore the database to an earlier state. In order to ... See More

 

Answer added by  rakan haddad, Oracle and Databse Developer, Takarub Telecommunication Company
9 years ago

No you cant 

 

Answer added by  Deepika Kumari, Software Engineer, Wipro Technologies
9 years ago

It is impossible to rollback after the transaction is commited.

 

Answer added by  Ganesh Sampat Abdagire, Senior .NET Developer, Qatar Islamic Bank
9 years ago

No you can not rollback the tranaction once commited.

 

Answer added by  Ashraf Abu Saed
9 years ago

Yes you can from sysadmin cancel the workflow and then you can use rollback_transaction procedure to delrte transaction using transaction_id

 

Answer added by  tariq abbas, Professional Services Engineer (Java/Android Developer/Blockchain), NIFT
10 years ago

once commited can't be rolled back .

 

Answer added by  Adnan Hamdani
10 years ago

You can't rollback any transaction once it is commited. but you need to do backup the database with transaction log. when ever you need to rollback, just restore the ... See More

 

Answer added by  Rajesh K, ISP Manager, CENPAC NET INC
10 years ago

Create a snapshot of database, then execute transaction. To undo the transaction, restore from the snapshot