oracle系统函数sys_context

最新推荐文章于 2022-04-25 10:21:13 发布

weixin_34183910

最新推荐文章于 2022-04-25 10:21:13 发布

阅读量153

点赞数

文章标签：数据库

本文介绍了如何使用SQL查询获取数据库名称、语言设置、终端类型、当前会话用户及模式等系统上下文信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

SYS_CONTEXT('USERENV','DB_NAME
--------------------------------------------------------------------------------
orcl

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

SYS_CONTEXT('USERENV','LANGUAG
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

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

SYS_CONTEXT('USERENV','TERMINA
--------------------------------------------------------------------------------
SUN-PC

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

SYS_CONTEXT('USERENV','SESSION
--------------------------------------------------------------------------------
SCOTT

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

SYS_CONTEXT('USERENV','CURRENT
--------------------------------------------------------------------------------
SCOTT