17,377
社区成员
发帖
与我相关
我的任务
分享
-- Created on 7/23/2014 by LEONCHENG
declare
-- Local variables here
l_str varchar2(100);
l_sql varchar2(200);
l_fnd_id varchar2(8);
begin
l_str := '''MPGF''';
l_sql := 'select fnd_id from (select ''MPGF'' FND_ID FROM DUAL UNION SELECT ''MPCF'' FROM DUAL) where fnd_id in(' ||
l_str || ')';
DBMS_OUTPUT.put_line(l_sql);
execute immediate l_sql
into l_fnd_id;
DBMS_OUTPUT.put_line(l_fnd_id);
end;
select * from table where instr(','||str||',',','||num||',')>0