Re: Getting the name of the database

From: Cynthia Tan <shinteia_at_yahoo.com>
Date: 23 Jul 1998 03:01:12 GMT
Message-ID: <01bdb5e6$b4132120$a07015a5@pc160>

Hi,

I am using

Select * from v$database

This provides a little more information about the database, whether it is in archive mode, etc ......

In fact, you could use the varible env to check which ORACLE_SID you are using.

Cheers,
Cynthia

calberto_at_my-dejanews.com wrote in article <6p21td$4m0$1_at_nnrp1.dejanews.com>...
Hi all!

Is there any function in Oracle that returns the name of the database I am using like there is SELECT USER FROM DUAL to get the username?

Thanks in advanced,

Carlos

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 22:01:12 CDT