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

How to shutdown your 10g xe server?

1148

what are actual and formal parameters?

1104

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

1020

How to resolve name conflicts between variables and columns?

1031

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How to insert multiple rows with one insert statement in oracle?

1085

Please explain drop constraint oracle?

1104

How to see free space of each tablespace?

1034

What is the disadvantage of User defind function?

2291

Explain the use of full option in exp command.

1116

Difference between cartesian join and cross join?

1039

what are archived logs?

2199

How can I create database in oracle?

1023

How to define an anonymous block?

1156

What is a system tablespace?

1071