Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can i get database name?
Ron wrote:
>
> I'm new to Oracle.
> How can i get all database name?
> i'm running oracle8.0.5 on Aix4.3.
SELECT
N.db_name || DECODE(D.db_domain, NULL, '', '.' || D.db_domain)
AS full_db_name
FROM (SELECT value AS db_name FROM v$parameter
WHERE LOWER(name) = 'db_name') N
, (SELECT value AS db_domain FROM v$parameter
WHERE LOWER(name) = 'db_domain') D ;
OR
SELECT
N.value || DECODE(D.value, NULL, '', '.' || D.value) AS full_db_name
FROM v$parameter N
, v$parameter D
WHERE LOWER(N.name) = 'db_name'
AND LOWER(D.name) = 'db_domain'
;
Valery Yourinsky
-- Oracle8 Certified DBA Moscow, RussiaReceived on Mon Apr 02 2001 - 02:31:01 CDT
![]() |
![]() |