oracle二次开发中的一些小细节

sunweijie22

oracle的一些有用的环境变量

select sys_context('USERENV','LANG') FROM DUAL
(Extracted from SQL Reference Documentation)
TERMINAL          The operating system identifier for the client of the
                  current session.  In distributed SQL statements, this
                  option returns the identifier for your local session.
                  In a distributed environment, this is supported only
                  for remote SELECTs, not for remote INSERTs, UPDATEs,
                  or DELETEs. (The return length of this parameter may
                  vary by operating system.)
LANGUAGE          The language and territory currently used by your session,
                  along with the database character set, in this form:
                    language_territory.characterset
LANG              The ISO abbreviation for the language name, a shorter form
                  than the existing 'LANGUAGE' parameter.
SESSIONID         The auditing session identifier.  You cannot use this
                  option in distributed SQL statements.
INSTANCE          The instance identification number of the current instance.  
ENTRYID           The available auditing entry identifier.  You cannot use
                  this option in distributed SQL statements.  To use this
                  keyword in USERENV, the initialization parameter AUDIT_TRAIL
                  must be set to TRUE.  
ISDBA             TRUE if you currently have the DBA role enabled and FALSE
                  if you do not.  
CLIENT_INFO       Returns up to 64 bytes of user session information that can
                  be stored by an application using the DBMS_APPLICATION_INFO
                  package.
NLS_TERRITORY     The territory of the current session.
NLS_CURRENCY      The currency of the current session.
NLS_CALENDAR      The current calendar of the current session.
NLS_DATE_FORMAT   The date format for the session.
NLS_DATE_LANGUAGE The language used for expressing dates.
NLS_SORT          BINARY or the linguistic sort basis.
CURRENT_USER      The name of the user whose privilege the current session is
                  under.
CURRENT_USERID    User ID of the user whose privilege the current session is
                  under.
SESSION_USER      Database user name by which the current user is authenticated.
                  This value remains the same throughout the duration of the
                  session.
SESSION_USERID    Identifier of the database user name by which the current
                  user is authenticated.
CURRENT_SCHEMA    Name of the default schema being used in the current schema.  
                  This value can be changed during the session with an ALTER
                  SESSION SET CURRENT_SCHEMA statement.
CURRENT_SCHEMAID  Identifier of the default schema being used in the current
                  session.
PROXY_USER        Name of the database user who opened the current session on
                  behalf of SESSION_USER.
PROXY_USERID      Identifier of the database user who opened the current session
                  on behalf of SESSION_USER.
DB_DOMAIN         Domain of the database as specified in the DB_DOMAIN
                  initialization parameter.
DB_NAME           Name of the database as specified in the DB_NAME
                  initialization parameter.
HOST              Name of the host machine from which the client has connected.
OS_USER           Operating system username of the client process that initiated
                  the database session.
EXTERNAL_NAME     External name of the database user.  For SSL authenticated
                  sessions using V.503 certificates, this field returns the
                  distinguished name (DN) stored in the user certificate.
IP_ADDRESS        IP address of the machine from which the client is connected.
NETWORK_PROTOCOL  Network protocol being used for communication, as specified
                  in the 'PROTOCOL=protocol' portion of the connect string.
BG_JOB_ID         Job ID of the current session if it was established by an
                  Oracle background process.  Null if the session was not
                  established by a background process.
FG_JOB_ID         Job ID of the current session if it was established by a
                  client foreground process.  Null if the session was not
                  established by a foreground process.
AUTHENTICATION_TYPE  How the user was authenticated:
                     DATABASE: Username/password authentication.
                     OS: Operating system external user authentication.
                     NETWORK: Network protocol or ANO authentication.
                     PROXY: OCI proxy connection authentication.
AUTHENTICATION_DATA  Data being used to authenticate the login user.  For
                     X.503 certificate authenticated sessions, this field
                     returns the context of the certificate in HEX2 format.

Note:  You can change the return value of the AUTHENTICATION_DATA
       attribute using the length parameter of the syntax.  Values of
       up to 4000 are accepted.  This is the only attribute of USERENV
       for which Oracle implements such a change.

例子：
   select userenv('CLIENT_INFO')
   from dual
   
   
      
select sys_context('USERENV','LANG') FROM DUAL

Terence

Thanks for your share!

bingmao0124

顶一下