Re: Should I Define CASCADE on Database Table or Forms ?
Date: 30 Sep 2004 07:37:53 -0700
Is 'whether the data only accessed from Forms app or other app' the only factor to be considered here ?
Will it be a problem if a table has 15 - 20 cascaded FKs refering to it ? will this cause performance issue ?
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1096518045.239319_at_yasure>...
> xtanto wrote:
> > Hi All,
> > We are developing Forms 10g application on Oracle 9i.
> > The question is :
> > For best practice on Master Detail application, should I define
> > cascade on database level or Forms level ?
> > Thank you foryour help,
> > xtanto
> You have provided insufficient information from which anyone could
> formulate a response.
> Do you want this behavior to only exist in the Forms application
> or to apply to any changes made to the data, perhaps by a DBA,
> using SQL*Plus?
Received on Thu Sep 30 2004 - 16:37:53 CEST