oracle批量删除同义词有关问题

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

[解决办法]

SQL code

beginfor v_synonym_name in(select synonym_name from user_synonyms where synonym_name like '%110110%') loopexecute immediate 'drop synonym '||v_synonym_name.synonym_name;--dbms_output.put_line('drop synonym '||v_synonym_name.synonym_name);end loop;end;
[解决办法]
先将要删除的同义词用查询语句拼接出来，然后拷贝出来执行就行了吧
[解决办法]
探讨

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