Re: how to get database name using sql statements

select name from v$database;

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 22 1999 - 08:39:45 CST