关于#sql#的问题，请各位专家解答！

select distinct 'create public synonym ' || a.OBJECT_NAME || ' for '|| 'zlhis.'|| a.OBJECT_NAME || ' ;'
from dba_objects a
where lower(a.OBJECT_NAME) like 'one_%' and a.OBJECT_TYPE = 'PROCEDURE'

这个sql没问题呀