--建立序列
create sequence Province_seq
start with 1
increment by 1
minvalue 1
maxvalue 9999999
nocycle
nocache
noorder;
--建触发器:
create or replace trigger Province_trigger
before insert on T_Province
for each row
begin
select Province_seq.nextval into:new.ProID from sys.dual;
end;