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 happened to the global index when I truncate the data in one of the partition?

2022

What is control file used for?

1209

ABOUT IDENTITY?

2058

How to get the Installed Oracle Version Information ?

1125

What is a trigger oracle?

1086

How to create a temporary table in oracle?

1268

What is the oracle implicit cursor?

1063

How can you merge two tables in oracle?

1001

Why use resource manager in Oracle?

1105

What are the data types in oracle?

1040

What do database buffers contain?

1031

Explain overloading. Can functions be overloaded?

986

What is a oracle database?

1055

Can you tell me how to add new column in existing views?how?How is possible?

1446

How remove data files before opening a database?

1072