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

How to create tables for odbc connection testing?

1084

How to use subqueries in the from clause in oracle?

1088

what happened to the global index when I truncate the data in one of the partition?

2008

Does oracle partitioning improve performance?

967

What privilege is needed for a user to delete rows from tables in another schema?

1045

What is an Oracle Instance?

1104

What is define in oracle?

1043

What is the database name in oracle?

1002

Can we store images in oracle database?

987

How to generate query output in html format?

1092

What are the types of trigger in oracle?

963

What are the different oracle database objects?

1075

What is flashback in Oracle?

1005

What is primefaces used for?

1034

How different is ms access and oracle?

1019