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 |
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Is oracle an open source?
 How to use an oracle sequence generator in a mapping?
What to do if dba lost the system password?
What is oracle open database communication (odbc)?
Describe an oracle table?
How to use regular expression in pattern match conditions in oracle?
What do you mean by redo log file mirroring?
Give the advantages and disadvantages of clusters.
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What is cursor