Oracle 一个owner访问另一个owner的table,不加owner

 --Oracle,one owner access another owner's tables,no need pre-owner
 --相当于alias(别名),比如把fms.US_SEARCH_AUDIT在fms_user中建一个同义词fms
 --under owner fms_user
 create synonym US_SEARCH_AUDIT for fms.US_SEARCH_AUDIT
 
 select * from fms_user.US_SEARCH_AUDIT
 select * from US_SEARCH_AUDIT
 select * from fms.US_SEARCH_AUDIT

posted on 2019-12-23 17:02  小柑  阅读(572)  评论(0编辑  收藏  举报