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, Russia