select SCN_TO_TIMESTAMP(ORA_ROWSCN) from table; This query shows all rec

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"

Question Posted / suresh babu

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Can we write dml statement in function in oracle?

1089

How to specify default values in insert statement using oracle?

1112

What are nested tables?

1178

Is it possible to split the print reviewer into more than one region ?

2281

What is bind variable in oracle 11g?

1041

What are triggers in oracle?

1043

How to create a new table in your schema?

1082

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1664

How to use in conditions in oracle?

1058

What is a proxy object?

1071

Explain drop constraint oracle?

1075

Can we protect our pl/sql source code?

1049

What is Undo Management Advisor in Oracle?

1103

What are the differences between blob and clob in oracle?

1090

Explain an extent?

1109