oracle的userenv和nls_lang详解 1、userenv最常见的使用 userenv函数返回当前会话（session）的相关信息。...以下sql语句可以查询当前会话连接的数据库字符集 select userenv('language') from dual; 有关userenv('parameter')返回值的官网介绍如下 ?...下面我们就去验证这种情况 2、windows上plsql使用userenv 先看下数据库真实的语言、地区和字符集 ? 再看下windows上NLS_LANG环境变量 ?...最后看下plsql上userenv执行的结果 ? 可以发现在windows上使用plsql的时候语言和地区使用的是plsql的环境变量NLS_LANG。...3、Linux上sqlplus使用userenv 首先看一下NLS_LANG为空的情况下userenv的返回值 ?
, SYS_CONTEXT('USERENV', 'ENTRYID') ENTRYID, --USERENV('ENTRYID') SYS_CONTEXT('USERENV'...'USERENV', 'HOST') HOST, -- USERENV('TERMINAL') SYS_CONTEXT('USERENV', 'IDENTIFICATION_TYPE')...('USERENV', 'LANG') LANG, --USERENV('LANG') SYS_CONTEXT('USERENV', 'LANGUAGE') LANGUAGE, --USERENV..., USERENV('LANGUAGE') 数据库字符集, USERENV('ISDBA') 是否DBA角色, USERENV('SESSIONID') 当前会话标识符..., USERENV('ENTRYID') 可审计的会话标识符, USERENV('LANG') 会话语言名称的ISO简记, USERENV('INSTANCE'
('USERENV','LANGUAGE') language, SYS_CONTEXT('USERENV','SESSIONID') sessionid, SYS_CONTEXT('USERENV...','INSTANCE') instance, SYS_CONTEXT('USERENV','ENTRYID') entryid, SYS_CONTEXT('USERENV','ISDBA'...USERENV','NLS_SORT') nls_sort, SYS_CONTEXT('USERENV','CURRENT_USER') current_user, SYS_CONTEXT(...'USERENV','CURRENT_USERID') current_userid, SYS_CONTEXT('USERENV','SESSION_USER') session_user,..., SYS_CONTEXT('USERENV','DB_NAME') db_name, SYS_CONTEXT('USERENV','HOST') host, SYS_CONTEXT(
SQL> SELECT SYS_CONTEXT('USERENV','TERMINAL') FROM dual; SYS_CONTEXT('USERENV','TERMINAL') ---------...SQL> SELECT SYS_CONTEXT('USERENV','HOST') FROM dual; SYS_CONTEXT('USERENV','HOST') -----------------...SQL> SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') FROM dual; SYS_CONTEXT('USERENV','IP_ADDRESS') -----...SQL> SELECT SYS_CONTEXT('USERENV','SERVER_HOST') FROM dual; SYS_CONTEXT('USERENV','SERVER_HOST') ---
('INSTANCE'),USERNAME FROM V$SESSION A WHERE A.PROGRAM LIKE '%PMON%'; SID SERIAL# USERENV('...使用SYS用户杀普通用户的会话如下所示： SYS@lhrdb21> SELECT A.SID,A.SERIAL#,USERENV('INSTANCE'),USERNAME FROM V$SESSION...A WHERE USERNAME='LHR'; SID SERIAL# USERENV('INSTANCE') USERNAME ---------- ---------- ----...使用LHR用户杀其它用户的会话： LHR@lhrdb21> SELECT A.SID,A.SERIAL#,USERENV('INSTANCE'),USERNAME FROM V$SESSION A WHERE...USERNAME='LHRTEST'; SID SERIAL# USERENV('INSTANCE') USERNAME ---------- ---------- -------
SYS@PROD1> select userenv('language') from dual; USERENV('LANGUAGE') --------------------------------...SYS@PROD1> select userenv('language') from dual; USERENV('LANGUAGE') --------------------------------
查询当前字符集： select userenv('language') from dual; USERENV('LANGUAGE') ---------------------------------...再查询字符集 SQL> select userenv('language') from dual; USERENV('LANGUAGE') ------------------------------
ON DATABASE BEGIN INSERT INTO stats$user_log VALUES (USER, SYS_CONTEXT ('USERENV...', 'SESSIONID'), SYS_CONTEXT ('USERENV', 'HOST'), NULL,...', 'SESSIONID') = audsid) WHERE SYS_CONTEXT ('USERENV', 'SESSIONID') = session_id; --********...', 'SESSIONID') = audsid) WHERE SYS_CONTEXT ('USERENV', 'SESSIONID') = session_id; -- *******...', 'SESSIONID') = audsid) WHERE SYS_CONTEXT ('USERENV', 'SESSIONID') = session_id; -- *******
INTO session_history SELECT sid ,username ,program ,machine ,sys_context('userenv...','ip_address') ,sysdate FROM v$session WHERE audsid = userenv('sessionid'); end; / 本机通过 lucifer...使用 DBMS_SESSION 程序包设置可以查询 IP 地址： exec DBMS_SESSION.set_identifier(SYS_CONTEXT('USERENV', 'IP_ADDRESS'...10.211.55.110/orcl alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'; select sys_context('userenv...on_logon_trigger after logon on database begin dbms_application_info.set_client_info(sys_context('userenv
Host_Var VARCHAR2(200); /* 终端主机名 */ BEGIN /* 获取登陆用户信息 */ SELECT SYS_CONTEXT('USERENV...','SESSIONID'), SYS_CONTEXT('USERENV','OS_USER'), SYS_CONTEXT('USERENV','IP_ADDRESS...'), SYS_CONTEXT('USERENV','TERMINAL'), SYS_CONTEXT('USERENV','HOST') INTO...','SESSIONID'), SYS_CONTEXT('USERENV','OS_USER'), SYS_CONTEXT('USERENV','IP_ADDRESS...'), SYS_CONTEXT('USERENV','TERMINAL'), SYS_CONTEXT('USERENV','HOST') INTO
B.SPID FROM GV$PROCESS B WHERE B.ADDR = A.PADDR AND B.INST_ID = USERENV...('SESSIONID') AND A.INST_ID = USERENV('INSTANCE'); INSERT INTO XB_AUDIT_DDL_LHR (ID,...SYS_CONTEXT('userenv', 'terminal'), --sys_context('userenv', 'host') NVL2(ORA_LOGIN_USER,...SYS_CONTEXT('USERENV', 'SESSION_USER'), SP_XB_AUDIT_DDL_LHR.DB_SCHEMA), -- SYS_CONTEXT...('USERENV', 'SESSION_USER') sys.login_user SP_XB_AUDIT_DDL_LHR.SID, ---- SYS_CONTEXT('USERENV',
','terminal') from dual; SYS_CONTEXT('USERENV','TERMINA --------------------------------------------...','language') from dual; SYS_CONTEXT('USERENV','LANGUAG --------------------------------------------...','db_name') from dual; SYS_CONTEXT('USERENV','DB_NAME ---------------------------------------------...','session_user') from dual; SYS_CONTEXT('USERENV','SESSION ----------------------------------------...','current_schema') from dual; SYS_CONTEXT('USERENV','CURRENT --------------------------------------
s.MACHINE, s.TERMINAL, s.PROGRAM, q.sql_text line, 'INSERT', sys_context('userenv...','ip_address') from v$sql q, v$session s where s.audsid=(select userenv('SESSIONID...','ip_address') from v$sql q, v$session s where s.audsid=(select userenv('SESSIONID...s.TERMINAL, s.PROGRAM, q.sql_text line, 'UPDATE', sys_context('userenv...','ip_address') from v$sql q, v$session s where s.audsid=(select userenv('SESSIONID
200 select * from NLS_DATABASE_PARAMETERS; SELECT * FROM NLS_SESSION_PARAMETERS; SELECT USERENV...SQL> SELECT USERENV ('language') FROM DUAL; USERENV('LANGUAGE') --------------------...确认后修改后的字符集： select * from NLS_DATABASE_PARAMETERS; SELECT * FROM NLS_SESSION_PARAMETERS; SELECT USERENV...SQL> SELECT USERENV ('language') FROM DUAL; USERENV('LANGUAGE') --------------------
object_schema => 'SCOTT', object_name => 'EMP', policy_name => 'FGA_TEST_01', audit_condition => 'SYS_CONTEXT(''USERENV...') = ''JINGYU'' ', statement_types => 'UPDATE'); END; / 这里主要是audit_condition的写法，有一个SYS_CONTEXT('USERENV...','SESSION_USER')写法： select * from dual where SYS_CONTEXT('USERENV','SESSION_USER') = 'JINGYU'; 测试一下，...证明这样写where条件是有效的： SQL> show user USER is "JINGYU" SQL> select * from dual where SYS_CONTEXT('USERENV'...SQL> show user USER is "LUDAN" SQL> select * from dual where SYS_CONTEXT('USERENV','SESSION_USER') =
------ TRUE SESSION 返回会话标志 SQL> select userenv('sessionid') from dual; USERENV('SESSIONID...') -------------------- 152 ENTRYID 返回会话人口标志 SQL> select userenv('entryid'...的标志 SQL> select userenv('instance') from dual; USERENV('INSTANCE') ------------------- ...1 LANGUAGE 返回当前环境变量 SQL> select userenv('language') from dual; USERENV('LANGUAGE') -----...TERMINAL 返回用户的终端或机器的标志 SQL> select userenv('terminal') from dual; USERENV('TERMINA ----
字符集 检查Oracle Server字符集最常用的方法有两种 ▶查询nls_database_parameters select * from nls_database_parameters; ▶使用userenv...函数 userenv函数返回当前会话（session）的相关信息。...以下sql语句可以查询当前会话连接的数据库字符集 select userenv('language') from dual; 有关userenv('parameter')返回值的官网介绍如下 ?...userenv函数的具体使用和当前会话字符集的取值详见以下链接 oracle的userenv和nls_lang详解 3、修改Oracle Server字符集 一旦数据库创建后，数据库的字符集理论上讲是不能改变的...6、整理补充 ▶数据库字符集 select * from nls_database_parameters ; select userenv('language') from dual; 以上两种方法取得的都是数据库字符集
INTO session_history SELECT sid ,username ,program ,machine ,sys_context('userenv...','ip_address') ,sysdate FROM v$session WHERE audsid = userenv('sessionid'); end; / --查询非SYS用户的登录记录
INTO session_history SELECT sid ,username ,program ,machine ,sys_context('userenv...','ip_address') ,sysdate FROM v$session WHERE audsid = userenv('sessionid'); end; / ?...使用DBMS_SESSION程序包设置可以查询IP地址 sqlplus / as sysdba exec DBMS_SESSION.set_identifier(SYS_CONTEXT('USERENV...10.211.55.110/orcl alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'; select sys_context('userenv...on_logon_trigger after logon on database begin dbms_application_info.set_client_info(sys_context('userenv
是在这里做成的(407行)： services.set(IWindowsMainService, new SyncDescriptor(WindowsManager, [machineId, this.userEnv...并把这个窗口保存到usedWindows里去了； （如果已经有打开的窗口，那么就用现成的窗口打开新的内容） usedWindows.push(this.openInBrowserWindow({ userEnv...: openConfig.userEnv, cli: openConfig.cli, initialStartup: openConfig.initialStartup,
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
腾讯会议
云直播
对象存储
