动态参数化查询,如: [英] Dynamic parameterized query with like
本文介绍了动态参数化查询,如:的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Normal赋值运算符工作正常,但就像操作不适用于存储过程中的以下查询一样,您能纠正查询的问题吗?
The Normal assignment operator is working fine but like operation is not working with below query in a Stored Procedure, Could you correct what is wrong with the query?
在基于查询的过程中仅更改为LIKE运算符时,将引发异常
On changing only to LIKE Operator below query based procedure throws exception
AND APP_FRAMES.APP_EXT_CODE =:IN_APP_EXT_CODE%; -- working
AND APP_FRAMES.APP_EXT_CODE LIKE %:IN_APP_EXT_CODE%; -- not working
工作代码:
QUERY_STR := 'select * from APP_FRAME_PROPERTIES,APP_FRAMES
Where APP_FRAME_PROPERTIES.APP_EXT_CODE = APP_FRAMES.APP_EXT_CODE
AND APP_FRAMES.APP_EXT_CODE =:IN_APP_EXT_CODE';
OPEN OUT_RESULT FOR QUERY_STR USING IN_APP_EXT_CODE;
推荐答案
您必须连接'%'
文字:
AND APP_FRAMES.APP_EXT_CODE LIKE '%' || :IN_APP_EXT_CODE || '%';
整个查询将是:
QUERY_STR := 'select * from APP_FRAME_PROPERTIES,APP_FRAMES
Where APP_FRAME_PROPERTIES.APP_EXT_CODE = APP_FRAMES.APP_EXT_CODE
AND APP_FRAMES.APP_EXT_CODE LIKE ''%'' || :IN_APP_EXT_CODE || ''%'' ';
这篇关于动态参数化查询,如:的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文