Oracle Database does not support USERENV function for queries - Oracle

Q.  Oracle Database does not support the USERENV function for queries.
- Published on 03 Aug 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - The true statement is

    - Oracle Database supports the USERENV function for queries only.

    - USERENV function - It returns information about the current session.
    - This information can be useful for writing an application-specific audit trail table or for determining the language-specific characters currently used by your session.
    - You cannot use USERENV in the condition of a CHECK constraint.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)