Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger on Sequence

Trigger on Sequence

From: Funing Liu <fliu_at_asgnet.psc.sc.edu>
Date: Thu, 16 Sep 1999 11:08:42 -0400
Message-ID: <37E107FA.5DD56A62@asgnet.psc.sc.edu>


Hi,

How to write or fire a trigger when the sequence.nextVal is executed?

For example
 I want to fire myTrigger when the statement

     select mySequence.nextval from dual;

Approciate your help.

Funing Liu Received on Thu Sep 16 1999 - 10:08:42 CDT

Original text of this message

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