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 view the data files in the current database?

592

What is the difference between pre-select and pre-query?

619

What are the parameters that we can pass through a stored procedure?

551

Explain overloading. Can functions be overloaded?

568

master table and child table performances and comparisons in Oracle ?

1661

What is procedure overloading in oracle?

544

How can we delete duplicate rows in a table?

560

Explain an integrity constrains?

694

How to invoke the data pump export utility?

555

how do u setup a replication site?

1494

Can we call procedure inside function in oracle?

604

What is the data pump import utility?

577

How can I see all tables in oracle?

538

How to update values in a table in oracle?

579

Can we create database in oracle using command line ?

581