1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

update function

Discussion in 'SQL PL/SQL' started by arivazhagan, Dec 19, 2010.

  1. arivazhagan

    arivazhagan Active Member

    Likes Received:
    Trophy Points:
    i want to see latest updated rows in oracle sql query
  2. Sadik

    Sadik Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    That's a very generic question. More details please...
  3. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    'Latest updated rows' relative to what criteria? Is there a process date column that is populated on insert/update for each row? Are you willing to learn Log Miner to read through the redo logs (and alert logs if you have them)? Oracle stores no such information internally regarding when a row has been updated outside of the SCN and that can be misleading as that is assigned at the block level and it's very possible that not all rows in a given block are updated at the same time. You could also configure transactional history to populate a secondary table with the prior and current row values for updated records along with the process date but I doubt very seriously you have that created.

    What is the purpose of this 'requirement'? Why do you need to see currently updated rows? In which specific table? As stated earlier Oracle keeps no such information on 'currently updated rows'; you will need to determine which tables in your databse for which you want this information available then configure those tables accordingly.

    More information from you would be most helpful.