创建序列
create sequence seq_id --创建序列
increment by 1 start with 1 nomaxvalue
创建触发器
create or replace trigger tri_userid--创建触发器
before insert on userinfo
for each row
declare new_key number;
begin
select seq_id.nextval into new_key from dual;
:new.userid:=new_key;
end;
创建存储过程
create or replace procedure insert_userinfo --用户注册
(parm_username varchar2,
parm_passwd varchar2,
parm_ename varchar2,
parm_logo varchar2,
parm_result out number)--返回值 1:成功，0:失败
as
n number;
begin
select count(*) into n from userinfo where username=parm_username;
if n=0 then
parm_result:=1;
insert into userinfo(username,userpwd,ename,logo)
values(parm_username,parm_passwd,parm_ename,parm_logo);
commit;
else
parm_result:=0;
end if;
end;
