select 'CREATE OR REPLACE SYNONYM "username1"."'||TABLE_NAME||'" FOR "username2"."'||TABLE_NAME||'";'
from user_tab_comments where table_type='TABLE';
查询结果:CREATE OR REPLACE SYNONYM "username1"."table_name" FOR "username2"."table_name";
select 'CREATE OR REPLACE SYNONYM "username1"."'||TABLE_NAME||'" FOR "username2"."'||TABLE_NAME||'";'
from user_tab_comments where table_type='TABLE';
查询结果:CREATE OR REPLACE SYNONYM "username1"."table_name" FOR "username2"."table_name";