1.创建同义词语句:
create public synonym table_name for user.table_name; |
2.删除同义词:
drop public synonym table_name; |
3.查看所有同义词:
select * from dba_synonyms |
项目使用
create or replace synonym cmfuser.SEQ_ONLINE_BANK_CMB for cmf.SEQ_ONLINE_BANK_CMB;
1.创建同义词语句:
create public synonym table_name for user.table_name; |
2.删除同义词:
drop public synonym table_name; |
3.查看所有同义词:
select * from dba_synonyms |
项目使用
create or replace synonym cmfuser.SEQ_ONLINE_BANK_CMB for cmf.SEQ_ONLINE_BANK_CMB;