Re: how to get database name using sql statements

From: Nisar Tareen <ntareen_at_attcanada.net>
Date: Sun, 28 Nov 1999 04:12:21 GMT
Message-ID: <FY104.4871$j%2.402@cabot.ops.attcanada.net>

Yes , U can get the database information

by giving following Commands.

Select * from v$database; or Select * from v$instance;

Your DBA had to make synonym for these tables and then grant select to public on these views.

Nisar Tareen

Noodles <noodles_at_aol.com> wrote in message news:19991127102557.15060.00000783_at_ng-fm1.aol.com...
> How about:
>
> select global_name from global_name;
>
> if you don't mind the whole string. You can substr out the ORA_SID if
that's
> all you want.
>
> Just my 2 Cents.
Received on Sat Nov 27 1999 - 22:12:21 CST