sys_context 获取环境上下文的函数

最新推荐文章于 2019-04-23 09:45:11 发布

csdn1027192414

最新推荐文章于 2019-04-23 09:45:11 发布

阅读量180

点赞数

select SYS_CONTEXT('USERENV','IP_ADDRESS') from dual;
--------------------------------------------------------------------------------
192.168.0.136

SQL> select sys_context('userenv','sid') from dual;

SYS_CONTEXT('USERENV','SID')
--------------------------------------------------------------------------------
129

SQL> select sys_context('userenv','terminal') from dual;

SYS_CONTEXT('USERENV','TERMINAL')
--------------------------------------------------------------------------------
TIMRAN-222C75E5

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

转载于:http://blog.itpub.net/31496956/viewspace-2639868/