Re: SQL SERVER TRIGGER TRANSLATION

Oracle triggers are VERY different from SqlServer ones... Read the docs on the various types
( BEFORE,AFTER,INSTEAD OF) (UPDATE,DELETE,INSERT) and replicate your logic, not your syntax in Oracle speak...

hth

Fred Burlaud <fburlaud_at_com6.fr> wrote:

>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
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Jun 26 2002 - 13:33:29 CDT