oracle批量删除同义词问题

Question

麻烦问下用oracle怎么批量删除相同前后缀的同义词啊？
我用 drop sysnonym where sysnoym_name like '%11010%'; 不行啊

Answer 1

begin
for v_synonym_name in
(select synonym_name from user_synonyms where synonym_name like '%110110%') loop
execute immediate 'drop synonym '||v_synonym_name.synonym_name;
--dbms_output.put_line('drop synonym '||v_synonym_name.synonym_name);
end loop;
end;

Answer 2

begin
for i in
(select owner,synonym_name from all_synonyms where synonym_name='EMP' like '%11010%')  loop
execute immediate 'drop '||i.owner||' synonym'||i.synonym_name;
end loop;
end;