【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了GetPwd.sql相关资料,希望对各位网友有所帮助!
CREATE FUNCTION UserMan.GetPwd
( name IN Users.UserName%Type )
RETURN Users.UserPwd%Type
AS
outpwd Users.UserPwd%Type;
BEGIN
SELECT UserPwd INTO outpwd FROM Users
WHERE UserName=''||name||'';
RETURN outpwd;
END;