Re: USERENV Function

From: John Y. Chan <john_at_rte-asset.com>
Date: 1997/10/24
Message-ID: <3450F904.7DD5_at_rte-asset.com>#1/1


AMARENDRA B NETTEM wrote:
>
> krishnanand_at_hotmail.com wrote:
> >
> > Hi,
> >
> > select userenv('SCHEMAID') from dual;
> >
> > What are all the Options that can be provided with
> > userenv function ?
> >
> > How to locate them ?
> >
> > Thanx.
> >
> > Krish.
> >
> > -------------------==== Posted via Deja News ====-----------------------
> > http://www.dejanews.com/ Search, Read, Post to Usenet
>
> SELECT USERENV('option') from dual;
>
> options: ENTRYID, SESSIONID,TERMINAL,LANGUAGE and LABEL
>
> --
> ******************************************************************************
> AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A
> Certified Oracle DBA NORRIDGE, IL 60656
> Whittman-Hart Inc.,
> 311 South Wacker Drive, Suite 3500
> Chicago, IL 60606.
>
> Ph.No. (708) 583 9870 (H)
> (312) 913 6758 (W)
>
> E-mail:nettama_at_charlie.cns.iit.edu,
> anettem_at_whittman-hart.com
>
> Homepage: http://www.iit.edu/~nettama
>
> ****************************************************************************
> Opinions are mine and do not necessarily reflect those of Whittman-hart
> Inc.

I tried it but it didn't work for SELECT USERENV('OPTION') FROM SYS.DUAL;

-- 
John Y. Chan
Received on Fri Oct 24 1997 - 00:00:00 CEST

Original text of this message