Re: important : deleting rows with PL/SQL

philippe wrote:

> i've studied on a project in which there were no option "delete cascade"
> on foreign keys but only instructions of deletions made manually
> and i have to reproduce the same construction of procedures in my
> present project
>
> so i wondered if there was a question of performance behind
>
> i prefer to use the option of deletion on cascade but i'm not sure i'm
> right

Is this school work?

You have three choices:

1. Use ON DELETE CASADE as Michel recommended.
2. Code a DELETE trigger
3. Code it the actions step by step into the proc. if one exists.

Option 3 is the worst of the lot.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)