Re: How to get the oracle SID name ?

select name from V$database;

Adrian (adrian.moor_at_swol.de) wrote:
: Hi everybody,

: does enybody know, how to get the oracle SID-ALIAS name (alias for the
: instance from the tnsnames.ora file)
: from a PLSQL programm or from sqlplus ?

: Im working with Oracle Rel. 7.3.

: my email is: adrian.moor_at_swol.de

: many thanks for your tip.

--
Best regards, Received on Sun Jan 03 1999 - 12:30:43 CST