create or replace PROCEDURE InsertUser
(
name in VARCHAR2(256),
password in number(64),
userExists out number
)
isbeginIF EXISTS (SELECT UserName FROM users WHERE UserName = name)
then
userExists := 1
RETURN
END if userExists := 0SELECT password = nvl(password, 0x691B0FBEED8F399F7E12576B090B217E4AD88A09)INSERT INTO Users
(UserName, Password)
VALUES
(name, password)RETURN
(
name in VARCHAR2(256),
password in number(64),
userExists out number
)
isbeginIF EXISTS (SELECT UserName FROM users WHERE UserName = name)
then
userExists := 1
RETURN
END if userExists := 0SELECT password = nvl(password, 0x691B0FBEED8F399F7E12576B090B217E4AD88A09)INSERT INTO Users
(UserName, Password)
VALUES
(name, password)RETURN
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货