select 'create synonym '||table_name||' for userName.'||table_name||';' from dba_tables where owner='USERNAME'
查询时用表名代替用户名.表名
最新推荐文章于 2021-11-23 23:14:25 发布
select 'create synonym '||table_name||' for userName.'||table_name||';' from dba_tables where owner='USERNAME'