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

2 Answers
5054 Views
Cognizant, I also Faced
E-Mail Answers

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

Post New Answer

More Oracle General Interview Questions

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers Cap Gemini,

How to display row numbers with the records?

0 Answers

How to shutdown your 10g xe server from command line?

0 Answers

Why we use bulk collect in oracle?

0 Answers

definition of cluster and non-clustered index?

0 Answers CSS,

State and explain about oracle instance?

0 Answers

How to rollback the current transaction in oracle?

0 Answers

How to Identify the previously inserted/updated records in already populated table.

0 Answers

what are the things that you consider while creating indexes on partitioning tables?

1 Answers

What is the difference between implicit index and explicit index?

2 Answers TCS,

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers Oracle,

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"

2 Answers Cognizant,

For more Oracle General Interview Questions Click Here