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 the usage of synonyms?

1216

What is oracle thin client?

1076

Give the constructs of a package, function or a procedure.

1096

How many types of table in Oracle?

1172

What are joins, explain all types of joins?

2361

What are oracle functions?

1088

What is the difference between hot backup and cold backup in oracle?

1078

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2334

What are advantages of dateset in datastage?

2309

How to work with data objects interactively?

1043

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2336

What happens if the imported table already exists?

1077

What is private procedure oracle?

1049

What is a named program unit?

1137

how to do daily transactions with out sql* loader control file regesterd in apps?

1730