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 do I know if oracle client is installed on windows?

What are the uses of Rollback Segment ?

List the various oracle database objects?

How to drop a stored function?

What are the advantages of oracle?

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

What are the factors causing the reparsing of SQL statements in SGA?

How to shutdown your 10g xe server from command line?

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

What language does oracle use?

What is SQL access advisor in Oracle?

Which database is better for os platform dependency?

For more Oracle General Interview Questions Click Here