Skip to content

Instantly share code, notes, and snippets.

@sytkov

sytkov/query.plsql

Created April 24, 2012 13:18
Show Gist options
  • Save sytkov/2479613 to your computer and use it in GitHub Desktop.
Save sytkov/2479613 to your computer and use it in GitHub Desktop.
Download ZIP
Get current user / schema name ( for session )
Raw
query.plsql
select Schemaname into v_ObjectType
from v$session
where audsid = TO_NUMBER( sys_context('userenv','sessionid') )
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment