Re: SQL SERVER TRIGGER TRANSLATION

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 26 Jun 2002 22:02:12 +0100
Message-ID: <3d1a2bd3$0$8508$cc9e4d1f@news.dial.pipex.com>

what does the trigger do?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Fred Burlaud" <fburlaud_at_com6.fr> wrote in message
news:3D19FA47.9010405_at_com6.fr...


> Hello,

>

> I fail in translating this sql server trigger with the oracle syntax

> especially on the syntax "from inserted"

>

> thank you ;o)

> Fred

>

>

> CREATE TRIGGER TR_UPDATE_ResAppelHisto

>     ON ResAppelHisto

>     FOR UPDATE

>     NOT FOR REPLICATION

>

>     AS

>     IF UPDATE(ResAppel)

>         BEGIN

>             DECLARE    @cpResAppel int

>             SELECT    @cpResAppel = ResAppel FROM inserted

>         UPDATE    Trig_ResAppelStat SET Cpt=Cpt+1 WHERE ResAppel =

> @cpResAppel

>     END

>

Received on Wed Jun 26 2002 - 16:02:12 CDT