1.创建表
create table userInfo(
userId number primary key,
userName varchar(15),
userPwd varchar(50)
);
2.建立索引
create sequence SEQ_USERINFO
minvalue 1 –最小值
nomaxvalue –不设置最大值
start with 1 –从1开始计数
increment by 1 –每次加1个
nocycle –一直累加,不循环
nocache; –不建缓冲区
3.建立触发器
create or replace trigger tri_sys_userInfo_tg
before insert on userInfo
for each row
when (new.userId is null)
begin
select SEQ_USERINFO.NEXTVAL into: new.userId from dual;
end;
4.插入数据
insert into userInfo(userName,Userpwd) values (‘admin’,’admin’);
insert into userInfo(userName,Userpwd) values (‘jim’,’jim’);