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

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

Question Posted / guest

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

Answer / 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

More Oracle General Interview Questions

what is the difference between restoring and recovering?

What is oracle data type?

What is a partition in oracle?

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

What is the difference between a hot backup and a cold backup in oracle?

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

How to end the current transaction in oracle?

What is Index Cluster ?

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

what is difference between table and view? where to use views? thanks in advance!

How to connect to a remote server?

For more Oracle General Interview Questions Click Here