Re: update cascade to child tables

In article <mark.smith%ccmail.19.010CFEA5_at_x400gw.msfc.nasa.gov>

           mark.smith%ccmail_at_x400gw.msfc.nasa.gov "mark smith" writes:

> I am trying to enable cascade updates to child tables (ORACLE 7) that have a
> defined Foreign Key to the Parent. The only reference I can find is on
> Cascade deletes. Is there any way to do this though table definitions?
>
>
> Thanks,
>
> mark.smith_at_msfc.nasa.gov
>

        You cannot perform cascade updates via declarative data integrity statements.

        You have to use database triggers.

        See chapter 8 of the application developers manual.

-- 
tim london