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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Should I Define CASCADE on Database Table or Forms ?

Re: Should I Define CASCADE on Database Table or Forms ?

From: xtanto <krislioe_at_gmail.com>
Date: 30 Sep 2004 07:37:53 -0700
Message-ID: <e1c9bd55.0409300637.790a2a1f@posting.google.com>


Hi,

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 ?

Thank you,
xtanto

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 - 09:37:53 CDT

Original text of this message

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