Monday, May 5, 2014

get the current user in PL/SQL oracle?

SELECT lower(sys_context('USERENV','SESSION_USER'))
  || '@'   || lower(sys_context('USERENV','DB_NAME'))
FROM dual;

No comments:

Post a Comment