17,377
社区成员
发帖
与我相关
我的任务
分享
declare
v_str_like varchar2(2000);
begin
for c in ( select 'x' as str from dual
union all
select 'xx' as str from dual
union all
select 'xxx' as str from dual)
loop
v_str_like:=v_str_like||'not like ''%'||c.str||'%'',';
end loop;
dbms_output.put_line(RTrim(v_str_like, ','));
end;