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 -> how to obtain the value of current_schema

how to obtain the value of current_schema

From: Dietmar Brueckmann <dietmar.brueckmann_at_lycos.de>
Date: Fri, 5 May 2006 08:12:17 +0200
Message-ID: <1hmw2qpgjqzpk.1uwy5npbhhdnh.dlg@40tude.net> 





Hello,



in an application I use 


"alter session set current_schema = A_SCHEMA"
to set the Schema where all data are located for avoiding excessive use of
synonyms for user schema.



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.
Thanks in advance!


-- 
Best regards
Dietmar Brueckmann


Received on Fri May 05 2006 - 01:12:17 CDT












Original text of this message













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