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: Triggers v Referential keys

Re: Triggers v Referential keys

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Fri, 31 Aug 2007 12:00:20 -0000
Message-ID: <1188561620.369380.37200@o80g2000hse.googlegroups.com>


On 31 ago, 13:50, Robert Mullen <rwbmul..._at_hotmail.com> wrote:
> Our company is about to purchase a product based on Oracle 10x. Strange
> thing is, there are no Referential Keys declared at all, only Triggers.
>
> Is this standard procedure in Oracle? Can Referential Keys be totaly
> substituted by Triggers? Would that be wise?
>
> Thanks,
>
> Bob

"Is this standard procedure in Oracle?"

No.

"Can Referential Keys be totaly substituted by Triggers?"

No. (isolation level / read commited...)

"Would that be wise?"

No.

HTH. Cheers.

Carlos. Received on Fri Aug 31 2007 - 07:00:20 CDT

Original text of this message

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