| Gai |
Posted: Jan 02, 2007 08:18:47 AM |
Total Post: 8
Joined: Aug, 2006
|
Which table does one query to know the number of updated rows of a table?
For example I update a table T1 and there have been 40 updates. Which oracle table would I query to find the # of updated rows. Thanks in advance. |
|
|
 Jayanta |
| Posted: Jan 04, 2007 04:04:16 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
updates dont have any data dictionary entry, and so is not recorded in the database, it is just a simple dml statement. so no way to know.
but it has redo log entry.
hope this will work
with regards
jayanta
|
|
|
|
|
| Gai |
| Posted: Jan 04, 2007 04:39:57 PM | |
|
Total Post: 8
Joined: Aug, 2006
|
Thank you Jayantha. This was asked to me in an interview. I dint know what the answer was! Thank you.
Gayathri
|
|
|
|
|
| Jayanta |
| Posted: Jan 05, 2007 03:45:04 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
