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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Inter-table references

Re: Inter-table references

From: Dale <dschmitz4_at_cox.net>
Date: Tue, 2 Aug 2005 19:18:44 -0500
Message-ID: <J0UHe.2472$HM1.186@okepread03>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1123022650.258612_at_yasure...
> Dale wrote:
>> I don't even know if my subject line makes sense...
>>
>> I'm trying to find out if there are ways that similar fields between
>> tables can be made dependent on each other for their values. That is, if
>> I define two tables with some similar fields, can I force one table to be
>> updated from the other outside of running a script to do so.
>>
>> I guess I'm looking to find out if Oracle has any attributes that would
>> cover such requirements, something that is a property between the tables
>> or such.
>>
>> That's as best as I can explain it. Hope this isn't too nebulous.
>>
>> Thanks.
>>
>> Dale
>
> What I think you are referencing is a Foreign Key Constraint, also
> known as a referential constraint. It is used to constrain the values
> in one field to those of another field in what is often refered to as
> a lookup table.
>
> www.psoug.org
> click on Morgan's Library
> click on Constraints
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

Wonderful, thank you. I had no idea what the language might be that would describe this relationship. With that in hand I can begin to look into things.

Thanks again,
Dale Received on Tue Aug 02 2005 - 19:18:44 CDT

Original text of this message

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