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