Oracle/PLSQL: UserEnv Function(轉自http://www.techonthenet.com/oracle/functions/userenv.php)
In Oracle/PLSQL, the userenv function can be used to retrieve information about the current Oracle session. Although this function still exists in Oracle for backwards compatibility, it is recommended that you use the sys_context function instead.
The syntax for the userenv function is:
userenv( parameter )
parameter is the value to return from the current Oracle session. The possible values are:
[@more@]
Parameter Explanation CLIENT_INFO Returns user session information stored using the DBMS_APPLICATION_INFO package ENTRYID Available auditing entry identifier INSTANCE The identifier number of the current instance ISDBA Returns TRUE if the user has DBA privileges. Otherwise, it will return FALSE. LANG The ISO abbreviation for the language LANGUAGE The language, territory, and character of the session. In the following format:
language_territory.charactersetSESSIONID The identifier of the auditing session TERMINAL The OS identifier of the current session
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/95530/viewspace-1023319/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle/PLSQL: Sys_Context Function(轉自http://www.techonthenet.com)OracleSQLContextFunctionHTTP
- Oracle 中的userenv()Oracle
- ORACLE USERENV函式Oracle函式
- Oracle Pipelined Table Functions(轉)OracleFunction
- Oracle WMSYS FunctionsOracleFunction
- Oracle Date FunctionsOracleFunction
- Analytic Functions in OracleFunctionOracle
- Oracle USERENV和sys_contextOracleContext
- oracle plsqlOracleSQL
- monitor sys and system user(轉自http://www.oracle.com)HTTPOracle
- oracle plsql例子OracleSQL
- plsql generate xml functionSQLXMLFunction
- oracle function overviewOracleFunctionView
- Oracle Table FunctionOracleFunction
- oracle function powerOracleFunction
- Oracle Pipelined Table FunctionsOracleFunction
- oracle INTERNAL_FUNCTIONOracleFunction
- Oracle Deterministic FunctionOracleFunction
- Oracle中USERENV和SYS_CONTEXT總結OracleContext
- oracle plsql(二)_plsql塊內之**冪OracleSQL
- Oracle/PLSQL: Grant/Revoke PrivilegesOracleSQL
- Oracle PLSQL Sever Pages TestOracleSQL
- oracle plsql函式大全OracleSQL函式
- Oracle Pipelined FunctionOracleFunction
- oracle function函式castOracleFunction函式AST
- BIRT呼叫oracle function薦OracleFunction
- a demo function of oracle for AKingFunctionOracle
- 【Oracle-資料庫維護】-Oracle中USERENV和SYS_CONTEXT總結Oracle資料庫Context
- oracle之PLSql語言(一)OracleSQL
- oracle plsql(三)_type_cursorOracleSQL
- ORACLE PLSQL語言參考OracleSQL
- oracle plsql儲存過程OracleSQL儲存過程
- Oracle基礎之function使用OracleFunction
- oracle create function 例項2OracleFunction
- Oracle Profile and PASSWORD_VERIFY_FUNCTIONOracleFunction
- oracle 鎖(轉自網路)Oracle
- plsql Oracle匯入dmp檔案SQLOracle
- 構建oracle function的小示例OracleFunction