T1: T2
A X--- this is updated record
B B
like this T1 table having no.of records updated. write a
query"retrive updated record from T2"
Answer Posted / suresh babu
select SCN_TO_TIMESTAMP(ORA_ROWSCN) from table;
This query shows all records timestamp.From this result you
can find record,which recently updated.
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
is there a tool to trace queries, like profiler for sql server?
How index is implemented in oracle database?
How can we find out the current date and time in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What do you mean by group by clause?
How to select an oracle system id (sid)?
What is an oracle function?
How to Truncate Table in Oracle
What is meant by a deadlock situation?
How to export your own schema?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to create a new user account in oracle?
Explain the truncate in oracle?
How is it different from a normal table?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?