SELECT * FROM ( ( SELECT * FROM T1 UNION SELECT * FROM T2 ) MINUS

Without giving condition how to retrieve the unmatched
records from table.

Question Posted / sudipta santra

Answer Posted / sudipta santra

SELECT * FROM (
(
SELECT * FROM T1
UNION
SELECT * FROM T2
)
MINUS
(
SELECT * FROM T1
INTERSECT
SELECT * FROM T2
) ) ;

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the numeric comparison operations?

1094

Explain the use of Merge statement in oracle 11g

1011

Difference between inner join vs where ?

1012

How to fetch the row which has the max value for a column?

983

What is the best way to do multi-row insert in oracle?

1049

How to convert dates to characters in oracle?

1019

How many types of synonyms in Oracle?

1104

Please explain joins in oracle?

1048

What is meant by raw datatype?

1045

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2325

What is a nested table and how is it different from a normal table?

1032

How to rollback the current transaction in oracle?

1039

What are the ways tablespaces can be managed and how do they differ?

2341

What suggestions do you have to reduce the network traffic?

938

What is the simplest tool to run commands on oracle servers?

986