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
- 4953 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 |
Which environment variables are absolutely critical in order to run the OUI?
where do i find oracle interview questions.
How to export your own schema?
How many types of cluster table in Oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is a data lock in oracle?
what is trigger?
What are the original export and import utilities?
What is a parameter file in oracle?
What is an oracle function?
What happens to the data files if a tablespace is dropped?
How to Remove the 3rd highest salary person record from table?
Oracle General 
