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
3997 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

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers CGI,

Define 'view' advantage ?

2 Answers AZTEC, TCS,

What is a Redo Log ?

3 Answers

What are the components of Logical database structure of ORACLE database?

4 Answers

Give the various exception types.

0 Answers

Does oracle database need java?

0 Answers

What is private procedure oracle?