--创建序列 create sequence seq start with 1 increment by 1;--对表创建trigger实现主键自增 create or replace trigger trg before insert on table_name for each row begin select seq.nextval into :new.userid from dual; end;
insert into t_name(userid) select rownum+1 from dual connect by rownum<10;
create sequence seq start with 1 increment by 1;--对表创建trigger实现主键自增
create or replace trigger trg
before insert on table_name
for each row
begin
select seq.nextval into :new.userid from dual;
end;