Re: Table that contains the Oracle_SID of the database ?

I lost track of references, but the question was:

> Can you get your ORACLE_SID by a select statement.

The answers posted are all retrieving the database name as set in the init.ora file upon database creation. This is NOT necessarily the same as the ORACLE_SID, although Oracle recommends you to make these two the same.

There is really no way to retrieve the value of the ORACLE_SID environment as a select statement.

EXEC SQL INCLUDE standard.disclaimer

-- 
Bjorn Engsig, ORACLE Corporation
Internet: bengsig_at_oracle.com, uucp: uunet!oracle!bengsig