Re: Find "current_schema"

"klabu" <klabu76_at_gmail_dot_com> wrote in message news:12ico51gtb8b0ad_at_corp.supernews.com...
> after I do
> "alter session set current_schema = scott"
>
> How do I later find out/verify what my "current_schema" is ?
>
> Thanks
>
>

Just checked on 9.2.0.6

select sys_context('userenv','current_schema') from dual;

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html