userenv is a functoin which which give informayion about the curent user
session
You can gather lot more info also
eg

SELECT USERENV(?LANGUAGE?) "Language" FROM DUAL;
select userenv('SESSIONID') "session identificaion" from
dual;
select userenv('client_info') from dual
select userenv('terminal') "terminal identificaion" from
dual;
but this has been replaced by sys_context in 9i
Oracle9i provides a built-in namespace called USERENV, which describes the
current session.
so we can use sys_context as
select sys_context('userenv','current_user') from dual;
select sys_context('userenv','authetication_type') from dual;
select sys_context('userenv','current_schema') from dual;
select sys_context('userenv','db_domain') from dual;
select sys_context('userenv','db_name') from dual;
select sys_context('userenv','instance') from dual;

regards
gopesh



"Arshad Jamil " <oracledba-ezmlmshield-x32090676.[Email address protected]
09/08/2004 03:04 PM


To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Pls .. Define this select query ....






Hello All,



Can any on define following query... ?

select userenv ('SESSIONID') from dual;

What is SESSIONID ... (function or procedure or ..... )?
What is userenv ...... ?

Pls. define complete SELECT query ..



Arshad Jamil


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html


ForwardSourceID:NT00004C66
DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery
of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services Limited. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the
addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services Limited
on any subject matter.]
Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Services Limited takes any responsibility or liability towards the same. Opinions, conclusions and any other
information contained in this message that do not relate to the official business of Tata Consultancy Services Limited shall be understood as neither given nor endorsed by Tata Consultancy Services Limited or any affiliate of Tata Consultancy Services Limited. If you have received this message in error,
you should destroy this message and may please notify the sender by e-mail. Thank you.



Oracle LazyDBA home page