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: How to write trigger for ON_DELETE_CASCADE?

Re: How to write trigger for ON_DELETE_CASCADE?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 16 Jun 2005 21:45:50 +0100
Message-ID: <m4p3b1hotl9r4skp34qgkgj2n8d49c59t3@4ax.com>


On 16 Jun 2005 02:17:37 -0700, ajay.sonawane_at_gmail.com wrote:

>I know that ON_DELETE_CASCADE is used to do so, But as I am using
>SQLite library and it doesn't have support for ON_DELETE_CASCADE, I
>need to write trigger to acheive the same thing.

 Hang on - you're using SQLite? That's a different SQL-based database - aren't you using Oracle?

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Received on Thu Jun 16 2005 - 15:45:50 CDT

Original text of this message

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