select * from T2 minus select * from T1

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 / suman rana

Answer Posted / suman rana

select * from T2
minus
select * from T1

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is private procedure oracle?

958

What is different types of joins?

969

What is oracle thin client?

974

What is connection pooling in oracle?

914

What is varray?

1036

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

968

How to call a stored function with parameters?

972

What is oracle database client?

976

What are transaction isolation levels supported by oracle?

997

6. Display the client name and order date for all orders using the traditional method.

2241

Please explain joins in oracle?

1009

How to omit columns with default values in insert statement in oracle?

1000

What are dml statements in oracle?

1045

How to connect to a local oracle 10g xe server?

938

why dont we assign not null constraint as table level constraint.

2685