Re: How to identify the 'current' instance
Date: 1996/10/14
Message-ID: <slrn565dvj.7qh.roby_at_h2net.net>#1/1
In article <53u9au$i7d_at_gw.PacBell.COM>, j4xprel_at_pbsrv10.isp.pacbell.com wrote:
>running under hp-ux, after exporting ORACLE_SID=TST, TWO_TASK=DEV and
>then logging on to sql*plus with 'sqlplus user_id_at_T:host_name:PRD' is
>there any way to query the correct current instance?
>
>thanks in advance.
>
select global_name from global_name;
This will report back the global_name of the current database.
--
--roby_at_h2net.net------------------------------------------------Denver, CO--
A well-used door needs no oil on its hinges.
A swift-flowing stream does not grow stagnant.
Neither sound nor thoughts can travel through a vacuum.
Data rots if not used.
These are great mysteries.
----------------------------------------------------------------------------
Received on Mon Oct 14 1996 - 00:00:00 CEST