Re: Sequence Question

From: <chereau>
Date: 1996/09/11
Message-ID: <515u7d$gei_at_cf01>#1/1

We can use sequence in trigger.

here is an exemple for the table emp :

CREATE OR REPLACE TRIGGER empno
BEFORE INSERT ON emp
FOR EACH ROW
BEGIN

	SELECT SEQ_EMP.NEXTVAL 
	INTO :new.empno
	FROM DUAL;

END;

---

As usual :
statements and opinions are mine and do not necessarily reflect the opinions of my employer.

/ Received on Wed Sep 11 1996 - 00:00:00 CEST