Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i SQL-Statement please help!

Re: Oracle 9i SQL-Statement please help!

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 02 Jul 2002 16:07:28 GMT
Message-ID: <3D21CF9C.859FA645@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US