Oracle入门精读88-Oracle存储过程的案例(insert,update,delete)

建登录用户表

create table temUser01

(

  userID int,

  userName varchar2(10 char),

  userPass char(10),

  userAge int

)

--insert into用户信息

create or replace procedure temUser01_Add(int_userID in int, str_userName in varchar,str_userPass in varchar, int_userAge in int)

as

begin

insert into temUser01(userID,userName,userPass,userAge) values(int_userID,str_userName,str_userPass,int_userAge);

commit;

end;

--update 用户密码

create or replace procedure temUser01_Update_Pass_byuserID(int_userID in int,str_userPass in varchar)

as

begin

update temUser01 set userPass=str_userPass where userID=str_userID;

commit;

end;

--delete用户资料

create or replace procedure temUser01_delete_byuserID(str_userID in int)

as

begin

delete from temUser01 where userID=str_userID;

commit;

end;

调用

//新增用户资料

begin

temUser01_Add(01,'msh','msh123',22);

end;