1.建立公共同义词
语法:CREATE PUBLIC SYNONYM synonym FOR [schema.]object;
['sɪnənɪm]
示例:CREATE PUBLIC SYNONYM public_emp FOR scott.emp;
使用同义词的示例:select * from public_emp where ename='SCOTT';
2.建立私有同义词
语法:CREATE SYNONYM synonym FOR [schema.]object;
['sɪnənɪm]
示例:CREATE SYNONYM private_emp FOR scott.emp;
使用同义词的示例:select * from
private_emp
where ename='SCOTT'; //当前用户查询
select * from scott.
private_emp
where ename='SCOTT';//其他用户查询
3.删除同义词
语法:DROP PUBLIC SYNONYM synonym; //删除公共同义词
DROP SYNONYM synonym; //删除私有同义词
4.显示同义词信息
语法:select table_owner,table_name from syn where synonym_name='PRIVATE_EMP';