T1: T2 A X--- this is updated record

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 / sreenu

Answers were Sorted based on User's Feedback

T1: T2 A X--- this is updated record B ..

Answer / suman rana

select * from T2
minus
select * from T1

Is This Answer Correct ?

0 Yes

1 No

T1: T2 A X--- this is updated record B ..

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

More Oracle General Interview Questions

what are views?

Which dictionary tables and/or views would you look at to diagnose a locking issue?

Difference between primary key and unique key ?

How to export your own schema?

can a table has a column that has only view data and in other columns we can change data?

What is Read-Only Transaction ?

Difference between NO DATA FOUND and %NOTFOUND?

Explain the use of ignore option in imp command.

How to grant create session privilege to a user in oracle?

What a SELECT FOR UPDATE cursor represent.?

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

What are the basic element of Base configuration of an oracle Database ?

For more Oracle General Interview Questions Click Here