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
