Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i SQL-Statement please help!
Lanying & Manfred Chen-Fischer wrote:
> How to find out the database SID name within a SQL*PLus session, only
> SQL-Statements!
>
> ManFis
SELECT name
FROM v$database;
or
SELECT instance_name
FROM v$instance;
Daniel Morgan Received on Tue Jul 02 2002 - 11:07:28 CDT