Re: how to get database name using sql statements

Try:

  select value from v$parameter where name = 'db_name';

HTH,
Brian

Praburam Conjeevaram wrote:
>
> 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 22 1999 - 08:12:23 CST