Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to obtain the value of current_schema

Re: how to obtain the value of current_schema

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 4 May 2006 23:27:52 -0700
Message-ID: <1146810472.860385.314160@u72g2000cwu.googlegroups.com> 





>Because of a problem with that, I'd like to see the current setting of

>CURRENT_SCHEMA, but I don't how to obtain it.




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



Hth,


    Vladimir M. Zakharychev


    N-Networks, makers of Dynamic PSP(tm)
    http://www.dynamicpsp.com
Received on Fri May 05 2006 - 01:27:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US