Re: Any variable that uniquely identify a DB instance?

Hi

Is this what you need ?
select instance from v$thread;

Thanks
C. Jepsen.

"Ron TJ HUANG" <ron_huang_at_psitech.com.tw> wrote in message news:8tlpni$ebr$1_at_news.seed.net.tw...
> Dear all,
>
> Is there any environment variable in the DB that uniquely identify a
> database instance?
>
> Many thanks.
>
> Ron.
>
>
>
Received on Wed Nov 01 2000 - 04:41:28 CST