Saturday, 28 June 2014

Oracle 12c New feature to get USER ID ORA_INVOKING_USERID

Oracle 12c New feature to get USER ID ORA_INVOKING_USERID


Returns the user id of the database user who invoked the current statement or view

Example:  (ORA_INVOKING_USER RETURN NUMBER)


SELECT ora_invoking_userid  FROM dual;

No comments:

Post a Comment