创建序列
CREATE SEQUENCE "HSSP_DEV"."HSS_TASK_PAY_BILL_S" MINVALUE 1
MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ;
HSS_TASK_PAY_BILL_S 为序列名 ,表示从1到 9999999999999999999999999999 步长为1进行递增
创建定时器
create or replace trigger HSS_TASK_PAY_BILL_T
before insert on HSS_TASK_PAY_BILL
for each
row
begin
select HSS_TASK_PAY_BILL_S.NEXTVAL into:new.TASK_PAYMENT_ID from dual;
end;
HSS_TASK_PAY_BILL为表名 ,TASK_PAYMENT_ID为需要自增的字段