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: insert / updating on mandatory 1:1 relationship

Re: insert / updating on mandatory 1:1 relationship

From: Chun-Yen <agichen_at_my-deja.com>
Date: Sat, 16 Sep 2000 11:09:09 GMT
Message-ID: <8pvkcf$dga$1@nnrp1.deja.com>

In article <39c30e40.262365008_at_news.supernews.com>,   bvh2_at_swbell.net (Bruce Van Horn) wrote:
> If two tables have a mandatory 1:1 relationship, is there any way to
> insert or update values in these tables without disable the constraint
> first? Will a trigger or stored proc do this?
>

Why didn't you combine them ??

--
U can use set constraint deferrable.





Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Sep 16 2000 - 06:09:09 CDT

Original text of this message

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