Discussion in 'SQL PL/SQL' started by arivazhagan, Dec 19, 2010.
i want to see latest updated rows in oracle sql query
That's a very generic question. More details please...
'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.