oracle中自增列！

--建立表空间
create table test (id number, name varchar2(20));

--建立序列
create sequence seq_test start with 1 increment by 1;

--建立触发器
create or replace trigger tri_test
before insert on test
for each row
when (new.id is null)
begin
select seq_test.nextval into :new.id from dual;
end;
/

--插入测试数据
insert into test (name) values ('abc');

--查询结果
select * from test;

--得到结果
        ID NAME                         
---------- ------------------------------
         1 abc 

--注意事项s
into :new.id from dual  注意into之后的空格
不要写成：into: new.id from dual