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
- 4964 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 the difference between UNION AND UNIONALL
Can Multiple instances be run on Single Machine???
Can multiple cursors being opened at the same time?
How do I spool to a csv formatted file using sqlplus?
Explain what are the uses of rollback segment?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Calculate difference between 2 date / times in oracle sql?
What are the components of logical database structure in oracle database?
how can we write trigger in trigger???????? can we write one trigger on two table???
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Explain oracle’s server parameter file.
What is meant by redo log buffer ?
Oracle General 
