oracle自增列的问题

--创建表 create table test ( id number primary key, name varchar2 not null ); --创建序列 create sequence test_seq start with 1 increment by 1;  --创建触发器 create or replace  trigger tri_test_zz before  insert  on test for each row begin     select test_seq.nextval  into :new.id   from dual; end;