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: alek <alexandru.tica_at_gmail.com>
Date: 4 May 2006 23:28:17 -0700
Message-ID: <1146810497.438900.290690@i39g2000cwa.googlegroups.com>


hi,

try this:
select sys_context('USERENV', 'CURRENT_SCHEMA') FROM DUAL;

alek. Received on Fri May 05 2006 - 01:28:17 CDT

Original text of this message

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