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: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Mon, 18 Sep 2000 14:24:24 GMT
Message-ID: <39C62598.9DAAC27@edcmail.cr.usgs.gov>

Bruce,

  You can use INSTEAD OF triggers to perform exactly what you are looking for. This option is available in Oracle 8 and higher.

HTH,
Brian

Bruce Van Horn wrote:
>
> If it were up to me, the table wouldn't contain such constraints but
> triggers instead that would be more flexible with what I want to
> accomplish.
>
> However, I didn't create the table, and I can't readily modify it
> since applications from other departments already run against it. The
> functionality used to access the database is compiled within a Java
> class so that's no help. I could decompile if I knew which one
> contained the functionality I need, but there are hundreds of classes
> within the jars that make up the apps.
>
> I am writing a different app that will access the tables. I was
> hoping for a peice of SQL I had not considered.
>
> On Sat, 16 Sep 2000 11:09:09 GMT, Chun-Yen <agichen_at_my-deja.com>
> wrote:
>
> >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.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Mon Sep 18 2000 - 09:24:24 CDT

Original text of this message

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