1.创建同义词
CREATE [PUBLIC] SYNONYM synonym
FOR object;
例1:为视图DEPT_SUM_VU创建一个简洁的名字
CREATE SYNONYM d_sum FOR dept_sum_vu;
例2:创建公共同义词提供给所有用户使用
CREATE PUBLIC SYNONYM dept FOR scott.dept;
2.查询同义词
1)私有同义词查询
SELECT synonym_name,table_owner,table_name
FROM user_synonyms;
2)公共同义词查询
SELECT owner,synonym_name,table_owner,table_name
FROM all_synonyms
WHERE table_owner='SCOTT'
AND owner='PUBLIC';
3.删除同义词
1)删除私有同义词
DROP SYNONYM d_dum;
2)删除公共同义词
DROP PUBLIC SYNONYM emp;