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 |
Explain a data segment?
What is the sid in oracle?
What is PL/SQL ?
How oracle handles dead locks?
What is not equal to in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
how to find out second largest value in the table
How many types of tables are there in oracle?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
What is oracle database client?
Explain a segment?