Re: Any variable that uniquely identify a DB instance?

There is no such thing as environment variables in Oracle (they belong on the OS side) - unless variables like user (in select user from dual, for example) are called that way - but you can: select name from v$database;
that will give you the db name from within an sql statement.

Syltrem

"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 Tue Oct 31 2000 - 07:52:10 CST