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: MERGE - INSERT/UPDATE

Re: MERGE - INSERT/UPDATE

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 4 May 2005 19:14:12 -0700
Message-ID: <1115259252.699062.141090@f14g2000cwb.googlegroups.com>


Presuming that sku_ATTR_ext is the same as SKU_ATTR_UPLOAD, for the merge statement to work,
the sku_id from sku_ATTR_ext must be found in sku (without the _ext) at the time or the merge statement.

This is my guess, as we would really need to 'know' what are the enabled foreign key constraints defined on SKU_ATTR.

HTH Received on Wed May 04 2005 - 21:14:12 CDT

Original text of this message

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