Saturday, 28 June 2014

Oracle 12c New feature to get USER ORA_INVOKING_USER

Oracle 12c New feature to get USER ORA_INVOKING_USER
 

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

Example: (ORA_INVOKING_USER RETURN VARCHAR2)

SELECT ora_invoking_user  FROM dual;

No comments:

Post a Comment