Re: how to get database name using sql statements

From: Jim Day <jday_at_fslso.com>
Date: Mon, 29 Nov 1999 14:14:43 -0500
Message-ID: <3843e1aa.0@news.hcs.net>

We have several programs that display the database instance name by using the following query:

select instance_name from v$instance;

Jim

"Praburam Conjeevaram" <praburam_at_sprint.ca> wrote in message news:DJ0_3.6707$MM.238827_at_newscontent-01.sprint.ca...
>
> I am new to oracle db.
> I am using sql plus to try sql commands.
> can someone tell me how to get the dbname to which i am connected.
> note:I am able to select records from tables
> Thanks
>
> -Prabu
>
>
>
>
>
>
>
>
Received on Mon Nov 29 1999 - 13:14:43 CST