create procedure ins_userinfo ( user_var in varchar2, address_var in varchar, phone_var in varchar ) is begin insert into userinfo values( user_var,address_var,phone_var); end;
exec ins_userinfo('ere','ere','erwe')
create procedure pro ( p_user_var in varchar2, p_address_var in varchar, p_phone_var in varchar ) is begin insert into userinfo values( p_user_var,p_address_var,p_phone_var); end;
( user_var in varchar2,
address_var in varchar,
phone_var in varchar
)
is
begin
insert into userinfo values( user_var,address_var,phone_var);
end;
( p_user_var in varchar2,
p_address_var in varchar,
p_phone_var in varchar
)
is
begin
insert into userinfo values( p_user_var,p_address_var,p_phone_var);
end;