1、使用拼接符号“||”
v_sql := 'SELECT * FROM UserInfo WHERE ISDELETED = 0 AND ACCOUNT =''' || vAccount || ''' AND PASSWORD = ''' || vPassword || '''';v_sql := 'SELECT * FROM UserInfo
阅读背景：
oracle存储过程中使用字符串拼接
来源：互联网
分享到：
