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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: getting server name and db name

Re: getting server name and db name

From: Soeren Degn Jahns <nospam_at_nospam.dk>
Date: Fri, 23 Jul 2004 15:08:20 +0200
Message-ID: <A58Mc.27059$Vf.1476075@news000.worldonline.dk>


> This is probably a very elementary question. I would like to have an sql
> which returns the name of the Oracle server and the current database.
Could
> anybody help me out?

Server name etc.:
http://www.orafaq.com/scripts/sql/ver.txt

Current database.:
http://www.orafaq.com/scripts/sql/whoami.txt

// Soeren Received on Fri Jul 23 2004 - 08:08:20 CDT

Original text of this message

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