current_schema

最新推荐文章于 2023-10-10 17:46:18 发布

congtuo6220

最新推荐文章于 2023-10-10 17:46:18 发布

阅读量406

点赞数

　　在Oracle中user代碼連接數据庫的帳號，schema代表user下所有對象的集合，默認情況下當前操作的當前user下的schema，可以通過設置current_schema這個參數來改變當前訪問的schema。

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

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8799875/viewspace-903560/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8799875/viewspace-903560/