Oracle Environment and Identifier Functions

Environment and identifier functions provide information about the instance and session. This page summarizes the Oracle environment and identifier functions.

  1. CON_DBID_TO_ID

    Oracle CON_DBID_TO_ID() is a built-in function that returns the container ID based on the container DBID.

  2. CON_GUID_TO_ID

    Oracle CON_GUID_TO_ID() is a built-in function that returns the container ID based on the container GUID.

  3. CON_NAME_TO_ID

    Oracle CON_NAME_TO_ID() is a built-in function that returns the container ID based on the container name.

  4. CON_UID_TO_ID

    Oracle CON_UID_TO_ID() is a built-in function that returns the container ID based on the container UID.

  5. ORA_INVOKING_USER

    Oracle ORA_INVOKING_USER is a built-in function that returns the name of the database user that invoked the current statement or view.

  6. ORA_INVOKING_USERID

    Oracle ORA_INVOKING_USERID is a built-in function that returns the identifier of the database user who invoked the current statement or view.

  7. SYS_CONTEXT

    Oracle SYS_CONTEXT() is a built-in function that returns the value of the given parameter associated with the given context at the current time.

  8. SYS_GUID

    Oracle SYS_GUID() is a built-in function that generates and returns a globally unique identifier composed of 16 bytes.

  9. UID

    Oracle UID is a built-in function that returns the unique identifier of the current user session.

  10. USER

    Oracle USER is a built-in function that returns the name of the current user for the session.

  11. USERENV

    Oracle USERENV() is a built-in function that returns information about the current session.