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

What is oracle host variable?

535

How to create tables for odbc connection testing?

495

Query to retrieve record for a many to many relationship ?

2081

How can I create database in oracle?

571

What is Undo Management Advisor in Oracle?

613

What are the different types of record groups in oracle? Explain each of them

605

How to convert numbers to characters in oracle?

590

What is oracle used for?

536

What are ddl statements in oracle?

592

What is a trace file and how is it created in oracle?

554

Explain the difference between sql and oracle?

582

How do I start tns listener?

542

How to update values on multiple rows in oracle?

602

What is open database communication (odbc) in oracle?

548

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

1837