-
Hi
when i update the table which has 10 rows but,i update only 2 rows .
if i want to know which rows had been upated latest.were should i see .how will i know which two rows of 10 rows were updated .
Thanks
lnr
html code is off
-
This I think is kind of hard to know. If you are looking for such senario, then do a select on the condition and then you will for sure know what are the rows that are going to get updated and then do an update. Other way to do this is fire a before update trigger and insert the old data into a temp table before you perform any kind of update. This is my one sense at this time.
Good luck,
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Hi
i want to know is there any table were i can find the latest updates .
i was thinking the row id will indicate but it was not showing any change at all .
Thanks
lnreddy
html code is off
-
no, no table with these changes. you will have to adopt one of sambavan's suggestions.
d.
-
I think if you enable the auditing for the respective tables, you can see the modified information.
-
-
Hi
I could nt catch it, what is logminer exactly .
i want to know is there any table to check for it
Thanks
lnreddy
html code is off
-
[url]http://www.dbasupport.com/forums/showthread.php?threadid=6070[/url]
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|