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
- 5059 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 |
How do you bind variables in oracle?
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
what is trigger?
What is oracle database 10g express edition?
What is catalog in Oracle?
What is the data pump import utility?
How can we force the database to use the user specified rollback segment?
What is hot backup and logical backup?
Explain enable novalidate constraint.
How do I reset a sequence in oracle?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
Explain the use of analyse option in exp command.
Oracle General 
