PL/SQL Developer创建id自增表步骤

PL/SQL Developer创建id自增表步骤

/1.创建表/
create table users(
id number(12) not null primary key, /设为主键/
username varchar(30) not null,
password varchar(50) not null
)

/2.创建序列/
create or replace sequence users_seq
minvalue 1
maxvalue 99999999999
start with 1
increment by 1
cache 20;

/3.创建触发器/
create or replace trigger users_tri before
insert on users for each row when (new.id is null) /当查到id为null的时常，触发插入/
begin
select users_seq.nextval into :new.id from dual ; /从虚拟表中查到下一个未被使用的新的id,使用过弃用，接着往下/
end;