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 sharding and partitioning?

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

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

What operating systems are supported by oracle database 10g xe?

How do I uninstall oracle client from windows?

What is a synonym? What are its various types?

Explain the different normalization forms?

What is the order of defining local variables and sub procedures/functions?

How can we find the size of a database?

How to add another datafile to a tablespace?

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

What happens if the imported table already exists?

For more Oracle General Interview Questions Click Here