Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    72

    Unanswered: Current schema name

    To change the schema we use "alter session set current_schema='xxxxx' "
    , like this is there any command to findout we were in which schema ?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Code:
    SELECT sys_context('USERENV', 'CURRENT_SCHEMA') FROM dual

  3. #3
    Join Date
    Jan 2010
    Posts
    72
    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •