相关代码如下：

1. 创建sequence：

复制代码 代码如下:

CREATE SEQUENCE SEQU_DATA_DATAINFO INCREMENT BY 1 START WITH 1 NOCYCLE NOCACHE NOORDER;

2. 创建触发器：

复制代码 代码如下:

create or replace TRIGGER TRIG_TEST

BEFORE INSERT ON TABLE1

FOR EACH ROW

DECLARE

tmpVar NUMBER;

BEGIN

tmpVar := 0;

Select SEQU_PROC_ASSOCIATEINFO.NextVal into tmpVar from dual;

:new.procid:=tmpVar;

EXCEPTION

WHEN OTHERS THEN

-- Consider logging the error and then re-raise

RAISE;

END;