–1、创建表
create table t_cases (id integer primary key,
name varchar(10) not null,
fsys varchar(30) not null,
cDesc varchar(30),
url varchar(30),
owner varchar(10),
updateTime date not null);
–2、创建自增序列
create sequence cases_sequence
increment by 1 --每次自增1
start with 1000 --从1000开始自增
nomaxvalue --不设置最大值
nocycle --不循环,一直累加
nocache; --不建缓冲区
–3、建立触发器
create trigger cases_id_autoincrement before
insert on t_cases for each row
when (new.id is null)
begin
select cases_sequence.nextval into:new.id from dual;
end;