Without giving condition how to retrieve the unmatched
records from table.
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
What are the differences between primary key and unique key?
What is the difference between a primary key & a unique key?
what is the scripts in data base?
What are nested tables?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to update values in a table in oracle?
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
Why is oracle database so popular?
How to see free space of each tablespace?
What is sequence?
How to convert a date to char in oracle? Give one example.
How to add another datafile to a tablespace?
How to connect to the server with user account: sys?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Is primary key indexed by default in oracle?