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

How to create a table interactively?

Name the various constraints used in oracle?

Explain oracle data types with examples?

What is a database table in oracle?

How to call a stored function with parameters?

what is the scenario where you take the database to NoArchivelog mode?

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

pls explain connect by prior with example and its real time use

how to hide the stored procedure inside a package

What does `(+)` do in a where clause?

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

What is the usage of synonyms?

For more Oracle General Interview Questions Click Here