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 a oracle database?

Why do we use coalesce function in oracle?

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

Explain index?

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

What are the predefined tablespaces in a database?

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

What is tns name?

What is Data Block ?

Explain the use of Merge statement in oracle 11g

What is the maximum number of CHECK constraints that can be defined on a column ?

Explain oracle left join with an example?

For more Oracle General Interview Questions Click Here