Re: Instance on Oracle 7.3.3

Doug Cowles <dcowles_at_bigfoot.com> :

> The V$instance on Oracle 8 supplies the instance name,
> wheras on Oracle 7 it doesn't. Is there another way to
> access which instance you are in in Oracle 7 just for safety?
>
> - Dc.
>

If things are set up correctly, try:

        select * from global_name;

However, a more foolproof method should be:

        select * from v$database;

Tim Received on Mon Jul 26 1999 - 18:05:22 CDT