在Oracle中user代碼連接數据庫的帳號，schema代表user下所有對象的集合，默認情況下當前操作的當前user下的schema，可以通過設置current_schema這個參數來改變當前訪問的schema。
[@more@]
USER02@HUIYI>create table t 2 ( 3 col1 varchar2(10) 4 ) 5 / Table created. USER02@HUIYI>create table user01.t 2 ( 3 col1 varchar2(10) 4 ) 5 / Table created. USER02@HUIYI>insert into t values('user02'); 1 row created. USER02@HUIYI>insert into user01.t values('user01'); 1 row created. USER02@HUIYI>commit; Commit complete. USER02@HUIYI>select * from t; COL1 -------------------- user02 USER02@HUIYI>select * from user01.t; COL1 -------------------- user01 USER02@HUIYI>alter session set current_schema=user01; Session altered. USER02@HUIYI>select * from t; COL1 -------------------- user01 USER02@HUIYI>col schemaname format a10 USER02@HUIYI>col username format a10 USER02@HUIYI>select schemaname,username from sys.v_$session where audsid = userenv('sessionid'); SCHEMANAME USERNAME ---------- ---------- USER01 USER02
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8799875/viewspace-903560/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
