Oracle基本操作笔试面试题之同义词操作

创建同义词


公共同义词
create public synonym table_name for owner.synonym_name;

私有同义词
create synonym table_name for owner.synonym_name;



2、删除同义词


删除公共同义词
drop synonym synonym_name public;

删除私有同义词
drop synonym synonym_name;