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 memory advisor in Oracle?

How to load data through external tables?

How many types of database triggers exist?

Explain an index segment?

What is open database communication (odbc) in oracle?

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

How to list all tables in your schema?

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

How can you Enforce Referential Integrity in snapshots ?

how will I find the first 5 highest salaried employees in each dept in oracle.

How to load a large xml file?

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

For more Oracle General Interview Questions Click Here