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

Where do we use decode and case statements?

992

ABOUT IDENTITY?

2035

What is a sub query? Describe its types?

1000

Is oracle an operator?

915

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1004

What is a sub query and what are the different types of subqueries?

1111

What is procedure overloading in oracle?

1037

Will you be able to store pictures in the database?

1095

Is the After report trigger fired if the report execution fails ?

2903

Why oracle is used?

1035

How do we get field detail of a table?

1062

What is bulk collect in oracle?

986

What is an oracle table?

971

How to get a list of all background sessions in the database?

977

What are a collation and state the different types of collation sensitivity?

1151