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

Home -> Community -> Usenet -> c.d.o.misc -> Re: important : deleting rows with PL/SQL

Re: important : deleting rows with PL/SQL

From: philippe <jftek_at_hotmail.com>
Date: Tue, 20 Jan 2004 11:32:01 +0100
Message-ID: <400D03A1.9070305@hotmail.com>

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

>>
>>

>
> Why not using ON DELETE CASCADE when creating the foreign key?
>
> Regards
> Michel Cadot
>
>
>
Received on Tue Jan 20 2004 - 04:32:01 CST

Original text of this message

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