Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 2 Answers
- 4918 Views
- Cognizant, I also Faced
- E-Mail Answers
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 |
What is a nested table?
How to define a specific record type?
What are the Limitations of a CHECK Constraint ?
How do I manually uninstall oracle client?
What is Public Database Link ?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
How to establish administrator authentication to the server?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the uses of synonyms?
How to Identify the previously inserted/updated records in already populated table.
What is indexing, and how does it improve performance?
How to do clean up if create database failed?
Oracle General 
