Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Show the name of instance through of SYS_CONTEXT

398814Jul 27 2004 — edited Jul 27 2004

Hi...

I need rescue the name of instance , but not have privileges on v$ views.

I use the function sys_context('USERENV','INSTANCE')

See:

SQL> select sys_context('USERENV','INSTANCE') from dual;

SYS_CONTEXT('USERENV','INSTANCE')
-------------------------------------------------------------
1

SQL>

Qeestions:

1.- How rescue the name of instance?
2.- The number of instance through SYS_CONTEXT is dynamic?

Regards
Hector Gabriel Ulloa Ligarius
Santiago of Chile
http://es.groups.yahoo.com/group/desarrolloOracle/

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2004

Added on Jul 27 2004

#general-database-discussions

5 comments

385 views