在游标中需要用到like
比如:
for c as select id from table where name like '刘%';
是可以的
但
declare xname varchar(100);
set xname = '刘%';
for c as select id from table where name like xname;
就不行。
...全文
2473打赏收藏
DB2中like后面跟变量的用法
在游标中需要用到like 比如: for c as select id from table where name like '刘%'; 是可以的 但 declare xname varchar(100); set xname = '刘%'; for c as select id from table where name like xname; 就不行。