Re: How to update

"Peloux" <olivierpeloux_at_yahoo.fr> a écrit dans le message de news:368998b3.0410210244.48bf19c6_at_posting.google.com...
> Hi,
> In a table i have a parent child relation :
>
> ID Name Description ParentId
> 1 data1 Description1 Null
> 2 data2 Description1 1
> 3 data3 Desscription1 1
>
>
> I would like to update child data when i update parent data with a
> trigger.
> Ex: If I update the description of the first line (ID=1), I would like
> that the rows referencing this line (parentId=1) has been updated !
>
>
> How can i do ?
>
> Thanks,
> Olivier

Have a look at Tom Kyte's white paper: "UPDATE CASCADE PACKAGE", url: http://osi.oracle.com/~tkyte/update_cascade/index.html

-- 
Regards
Michel Cadot