同义词相当于alias(别名)
比如在schema2中创建schema1.table的同义词table1
则在schema2中执行select * from table1时,就相当于在执行select * from schema1.table
创建同义词语法:
create synonym table1 for user1.table1;
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4万+

被折叠的 条评论
为什么被折叠?



