select 'CREATE SYNONYM CCP_RELATION.USER_'||object_name||' FOR EMS_USER.'||object_name||';' from dba_objects
where owner='EMS_USER' and object_type in('TABLE');
oracle 创建同义词
最新推荐文章于 2024-06-05 17:22:10 发布
select 'CREATE SYNONYM CCP_RELATION.USER_'||object_name||' FOR EMS_USER.'||object_name||';' from dba_objects
where owner='EMS_USER' and object_type in('TABLE');