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"
Answers were Sorted based on User's Feedback
Answer / 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 |
how to handle exceptions in post production
What is the relationship among database, tablespace and data file?
Difference between inner join vs where ?
What is max rowid in oracle?
How to convert numbers to characters in oracle?
How to define an explicit cursor in oracle?
Write a simple Store procedure and pass parameter to it ?
What is the difference between sharding and replication?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
Point out the difference between user tables and data dictionary?
Explain a private synonyms?
How to display employee records who gets more salary than the average salary in the department?