SELECT * FROM ( ( SELECT * FROM T1 UNION SELECT * FROM T2 ) MINUS

Without giving condition how to retrieve the unmatched
records from table.

Question Posted / sudipta santra

1 Answers
4877 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to export data to a csv file?

1197

What is a table index?

1009

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2251

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2092

Explain what are the uses of rollback segment?

960

definition of cluster and non-clustered index?

2958

What is the purpose of tables, private synonyms and public synonyms in Oracle?

976

Explain the use of control file?

1059

How to select all columns of all rows from a table in oracle?

988

Why cursor variables are easier to use than cursors?

1019

How to delete a user account in oracle?

911

Is a rollback possible to any savepoint?

997

What is bulk collect in oracle?

953

Explain database link?

1058

How to use fetch statement in a loop?

970