17,377
社区成员
发帖
与我相关
我的任务
分享
DECLARE
inattr varchar2(50) := '''你'',''我''';
sql_str varchar2(100);
summ number(5);
BEGIN
sql_str:='SELECT count(1) FROM tm_t_index_mate t WHERE t.INDEX_KEY IN ('||inattr||') AND t.data_type like ''A%''';
execute immediate sql_str into summ;
dbms_output.put_line(summ);
END;