query help

  • From: "Kommareddy, Srinivas (MED, Wissen Infotech)" <Srinivas.Kommareddy@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 8 Mar 2004 02:04:58 -0600

HI All,
 
I want to perform date load from table A to table B. Its failing with unique
constraitn problem.
 
Could someone post me to find out the rows that are already existing in
TABLE B (target table) (which are in table A i.e. source table).
 
(better than a union all)
 
(tables are big they have more than 1 million rows)
 
 
Tx and Regards,
Srinivas

Other related posts: