创建存储过程
create or replace procedure web_shopping_usersysna
(
p_phone in varchar2
)
as
begin
insert into web_shopping_user(UUID,PASSWORD,REGPHONENUM,EMAIL,IDENTITYCARD) values
(web_shopping_user_seq.nextval,'111111',p_phone,p_phone,p_phone);
end;
/
执行存储过程
execute web_shopping_usersysna(1212);
删除存储过程
drop procedure web_shopping_usersysna;
create or replace procedure web_shopping_usersysna
(
p_phone in varchar2
)
as
begin
insert into web_shopping_user(UUID,PASSWORD,REGPHONENUM,EMAIL,IDENTITYCARD) values
(web_shopping_user_seq.nextval,'111111',p_phone,p_phone,p_phone);
end;
/
执行存储过程
execute web_shopping_usersysna(1212);
删除存储过程
drop procedure web_shopping_usersysna;