对,目的是为了实现流水号,sequence已经建了,如下 CREATE SEQUENCE ALERT_USER.SEQ_TASK_ID START WITH 1 INCREMENT BY 1 MINVALUE 1 NOCACHE NOCYCLE NOORDER 可是怎么跟PA_TASK.TASK_ID关联呢
已经搞定,建触发器如下:CREATE OR REPLACE TRIGGER ALERT_USER.TIG_TASK_ID BEFORE INSERT ON ALERT_USER.PA_TASK REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE BEGIN SELECT SEQ_TASK_ID.NEXTVAL INTO :NEW.TASK_ID FROM dual; END ;
CREATE SEQUENCE ALERT_USER.SEQ_TASK_ID
START WITH 1
INCREMENT BY 1
MINVALUE 1
NOCACHE
NOCYCLE
NOORDER 可是怎么跟PA_TASK.TASK_ID关联呢
BEFORE INSERT
ON ALERT_USER.PA_TASK
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
BEGIN
SELECT SEQ_TASK_ID.NEXTVAL INTO :NEW.TASK_ID FROM dual;
END ;