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: SQL/SID question

Re: SQL/SID question

From: Andreas Hess <ahess_at_truworths.co.za>
Date: 1997/09/30
Message-ID: <01bccdb1$1cd11060$300610ac@trahe>#1/1

Hi

If you're connected as SYS or SYSTEM,

select name from v$database will give you the database name...

Hope this helps,

Andreas

Haresh Assumal <assumal_at_sprynet.com> wrote in article <01bccdab$b6836f60$fab1aacc_at_mycomp.intermediainc.com>...
> How do I find what my current SID is when I'm in SQLplus?
> -Haresh
>
Received on Tue Sep 30 1997 - 00:00:00 CDT

Original text of this message

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