Oracle批量创建同义词

发布时间：2020-12-12 15:41:02 所属栏目：百科来源：网络整理

导读：begin for arr in ( select 'create or replace synonym ' || b.OBJECT_NAME || ' for ' || B.OWNER || '.' || B.OBJECT_NAME row_i from dba_objects B where OWNER = 'APPS' AND object_type = 'TABLE' ) loop begin execute immediate (arr.row_i); EXCEPT

begin for arr in ( select 'create or replace synonym ' || b.OBJECT_NAME || ' for ' || B.OWNER || '.' || B.OBJECT_NAME row_i from dba_objects B where OWNER = 'APPS' AND object_type = 'TABLE' ) loop begin execute immediate (arr.row_i); EXCEPTION WHEN OTHERS THEN dbms_output.put_line(arr.row_i); end; end loop; end;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!