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 lov dynamically at runtime & attach to text field?

1097

Explain implicit cursor.

960

why dont we assign not null constraint as table level constraint.

2683

Is there any function in oracle similar like group_concat of mysql?

986

How to get execution path reports on query statements?

927

What is not equal to in oracle?

951

How will you write a query to get a 5th rank student from a table student_report?

1813

What are the differences between interval year to month and interval day to second?

963

How to get execution statistics reports on query statements?

1005

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2292

Can we protect our pl/sql source code?

992

How to create a new table in oracle?

1064

What is object data modeling?

903

Can a formula column be obtained through a select statement ?

2263

What are a query and state the different types of queries and their uses?

940