Re: USERENV Function

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.