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: Trigger Help

Re: Trigger Help

From: Paul Q <paulq_at_home.com>
Date: Thu, 22 Jul 1999 21:34:15 GMT
Message-ID: <r7Ml3.4508$um6.41484@news2.rdc1.on.home.com>


create a sequence max 1000 start 0 and cycle it

Mark Young wrote in message <7n7r36$os2$1_at_bgtnsc01.worldnet.att.net>...
>I would like to return the value of a field back to 0 once the value
reaches
>1000 using a trigger
>
>I have the following:
> if (:new.senumber=1000) then
> begin
> update mytable set senumber=0 where mycondition=mycondition
> end;
> end if;
>
>The trigger will be executed on an update of the senumber column.
>
>Any help would be greatly appreciated.
>
>mark_a_young_at_worldnet.att.net
>
>
>
>
>
Received on Thu Jul 22 1999 - 16:34:15 CDT

Original text of this message

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