Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I insert and avoid failing on account of duplicate rows?

Re: How can I insert and avoid failing on account of duplicate rows?

From: <arijitchatterjee123_at_yahoo.co.in>
Date: 18 Feb 2005 22:00:04 -0800
Message-ID: <1108792804.751066.308260@l41g2000cwc.googlegroups.com>


I think in your table
CREATE TABLE ROOMS_TO_CLEAN (

  BUILDING_ID  NUMBER NOT NULL,
  FLOOR_ID     NUMBER NOT NULL,
  ROOM_ID      NUMBER NOT NULL,

  PRIMARY KEY (BUILDING_ID, FLOOR_ID, ROOM_ID) );
need a date column.If date column is present then

 INSERT ROOMS_TO_CLEAN(BUILDING_ID, FLOOR_ID, ROOM_ID) SELECT m.BUILDING_ID, m.FLOOR_ID, m.ROOM_ID

    FROM PartyLocations m
   WHERE m.PartyDate = '2005-02-14'
minus
SELECT n.BUILDING_ID , n.FLOOR_ID, n.ROOM_ID

    FROM ROOMS_TO_CLEAN n
   WHERE n.<DateField> = '2005-02-14'

Regards
Arijit Chatterjee Received on Sat Feb 19 2005 - 00:00:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US