Xref: alice comp.databases.oracle.misc:47941
Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news.gsl.net!gip.net!europa.netcrusader.net!206.191.82.231!rockie.attcanada.net!172.31.25.103!prairie.attcanada.net!newsfeed.attcanada.net!172.31.25.102!cabot.ops.attcanada.net.POSTED!not-for-mail
From: "Nisar Tareen" <ntareen@attcanada.net>
Newsgroups: comp.databases.oracle.misc
References: <81jbo9$cdc$1@news1.xs4all.nl> <19991127102557.15060.00000783@ng-fm1.aol.com>
Subject: Re: how to get database name using sql statements
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <FY104.4871$j%2.402@cabot.ops.attcanada.net>
Date: Sun, 28 Nov 1999 04:12:21 GMT
X-Trace: cabot.ops.attcanada.net 943762341 142.194.185.19 (Sun, 28 Nov 1999 04:12:21 GMT)
NNTP-Posting-Date: Sun, 28 Nov 1999 04:12:21 GMT


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@aol.com> wrote in message
news:19991127102557.15060.00000783@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.