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
- 4921 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 Read-Only Transaction ?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to loop through a cursor variable?
what is difference between foreign key and reference key
What are temporal data types in oracle?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
What is an oracle user role?
difference between truncate and delete ,drop?
How do I escape a reserved word in oracle?
Can a field be used in a report without it appearing in any data group ?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
Explain the use of grant option in imp command.
Oracle General 
