Home » SQL & PL/SQL » SQL & PL/SQL » To roll back the updated records
To roll back the updated records [message #322992] Tue, 27 May 2008 00:32 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi to all,

I have updated some rows in a table and i have commited that. Now i want to find the rows to which i have updated.

id Name

1 A
2 B
3 A
4 A
5 A
6 C


I have updated all A to B and commited. Whether i can find the rows to which i have updated or to rollback.

I know that once commited it can't be rollback.


Thanks in Advance,
Seenu
Re: To roll back the updated records [message #322993 is a reply to message #322992] Tue, 27 May 2008 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version (4 decimals)? Possibility depends on version.

Regards
Michel
Re: To roll back the updated records [message #323060 is a reply to message #322993] Tue, 27 May 2008 03:56 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


The version we use is oracle 10g Release 2.


Thanks & Regards,
Seenu
Re: To roll back the updated records [message #323062 is a reply to message #323060] Tue, 27 May 2008 04:00 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- flashback query
- transaction flashback query
- log miner


Regards
Michel
Previous Topic: Random Password Generation
Next Topic: How to combine rows that meet criteria in SQL
Goto Forum:
  


Current Time: Mon Dec 05 09:10:35 CST 2016

Total time taken to generate the page: 0.09711 seconds