Oracle中没有已定义好的自动编号列,需要自己创建
1、创建表
create table test(id int,
name varchar(32))
2、创建序列
create sequence TID_seq
minvalue 1
maxvalue 999999
start with 1
increment by 1
cache 20
;
3、创建触发器
create or replace trigger test_tri
before insert on test for each row
begin
select to_char(TID_seq.nextval) into :new.id from dual;
end test_tri;
4、插入数据
insert into test(name) values ('a')
insert into test(name) values ('b')
select * from test