CREATE OR REPLACE PROCEDURE Login
(p_userID in varchar2,p_pwd in varchar2,errCode out int)
is
num number;
begin
Select count(*) into num FROM Users Where UserID = p_userID AND pwd = p_pwd;
if num>0 then
errCode := 1;
else
errCode := 0;
end if;
end;
/
(p_userID in varchar2,p_pwd in varchar2,errCode out int)
is
num number;
begin
Select count(*) into num FROM Users Where UserID = p_userID AND pwd = p_pwd;
if num>0 then
errCode := 1;
else
errCode := 0;
end if;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货