Xref: alice comp.databases.oracle.server:83154
Path: alice!news-feed.fnsi.net!enews.sgi.com!newsfeed.mathworks.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: gard.haugen@mogul.no
Newsgroups: comp.databases.oracle.server
Subject: Trigger on same table that we want to insert and update
Date: Wed, 02 Feb 2000 23:50:52 GMT
Organization: Deja.com - Before you buy.
Lines: 24
Message-ID: <87afsr$969$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Feb 02 23:50:52 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.1 x38.deja.com:80 (Squid/1.1.22) for client 212.45.167.100
X-MyDeja-Info: XMYDJUIDgardh

Hi,

We have a table T1 that we want to trigger insert, update and delete
activity on.

The problem is that for the insert-trigger we want to insert a new
record into the same table (T1), and the same goes for update and
delete:
On insert we want to insert a new (different) record in table T1
On update we want to update a different record in table T1
On delete we want to delete a different record in table T1

Is this possible without going into a loop ?

Regards,

Gard A. Haugen
Mogul AS
Norway



Sent via Deja.com http://www.deja.com/
Before you buy.