updation --dml statement
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: updation --dml statement

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  3. #3
    Join Date
    Jan 2001
    Posts
    60
    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

  4. #4
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    no, no table with these changes. you will have to adopt one of sambavan's suggestions.

    d.

  5. #5
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    I think if you enable the auditing for the respective tables, you can see the modified information.

  6. #6
    Join Date
    Jul 2000
    Posts
    296
    Or in 8i use logminer.

  7. #7
    Join Date
    Jan 2001
    Posts
    60
    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

  8. #8
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    [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
  •  


Click Here to Expand Forum to Full Width