oracle 通过序列实现某字段自增

-- 创建表

create table items(

       id int primary key,

       name varchar(32) not null,

       price int not null,

       detail varchar(100),

       pic varchar(512),

       createtime date

);

-- 创建序列

create sequence sq_items

-- 自增步长

increment by 1

-- 始值

start with 1

-- 没有最大值

nomaxvalue

-- 不循环

nocycle;

--创建触发器，将序列与表的字段关联起来，并实现自增

create or replace trigger itmes_trig

before insert on items

for each row

declare

begin

 select sq_items.nextval into :new.id from dual;

end items_trig;

insert into items (name,price) values('lf',12);

insert into items (name,price) values('tl',22);

insert into items (name,price) values('lt',22);

select * from items;