oracle id 自增

-- Create sequence
create sequence WORKSHOP_ID
minvalue 1
maxvalue 99999999999999999999
start with 1
increment by 1
nocache;

create or replace trigger trigger_WORKSHOP_insert
before insert on WORKSHOP
for each row
declare
-- local variable here
begin
-- Column "Goods_ID" uses sequence GOODS_GOODS_ID
select WORKSHOP_ID .nextval into :new.ID from dual;
end trigger_WORKSHOP_insert;