Skip to content

Instantly share code, notes, and snippets.

@yashk
Created December 9, 2011 17:07
Show Gist options
  • Save yashk/1452407 to your computer and use it in GitHub Desktop.
Save yashk/1452407 to your computer and use it in GitHub Desktop.
get current schema from db - oracle
select sys_context( 'userenv', 'current_schema' ) from dual;
@pouya1364
Copy link

Thanks, working fine for me.

@kimaniw
Copy link

kimaniw commented Dec 14, 2022

Thanks mate this was very useful

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment