select * from BANK t; DECLARE v_money bank.money%TYPE; BEGIN --简单执行sql,注意sql字符串不要带分号结束 EXECUTE IMMEDIATE "S
select * from BANK t;
DECLARE
v_money bank.money%TYPE;
BEGIN
--简单执行sql,注意sql字符串不要带分号结束
EXECUTE IMMEDIATE "SELECT money FROM bank WHERE id = 5";
--带参数,参数使用using传入,按顺序的传入
EXECUTE IMMEDIATE "SELECT money FROM bank WHERE id = :param1 or id =:param2"
USING "4","5";
--执行sql后,取值,using在赋值后面
EXECUTE IMMEDIATE "SELECT money FROM bank WHERE id = :param1"
INTO v_money
USING "2";
DBMS_OUTPUT.PUT_LINE( "Column Variable: " || v_money );
END;
--结束END--
本文标题: plsql EXECUTE IMMEDIATE动态执行sql
本文链接: https://www.lsjlt.com/news/6863.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0