Re: How can I find out which database i'm currently in?

From: Glen A Stromquist <gstrom_at_nosppamtelusplanet.net>
Date: Sat, 13 Apr 2002 15:24:06 GMT
Message-ID: <q4Yt8.10421$6G4.218921@news1.telusplanet.net>

select name from v$database

better yet, configure your sqlplus prompt to show which db you are in by editing your glogin.sql script, you can even have it show who you are logged in as. A google search will bring you lots of possibilities here

hth

"Max Adams" <RubberDucky703_at_hotmail.com> wrote in message news:a99cfc$1e942$1_at_ID-116287.news.dfncis.de...
> How can I find out which database i'm currently in?
>
> I'm logged into Oracle via the SQL*Plus command line utility using Oracle
8i
> Enterprise Edition (8.1.7)
>
> Is there a command which will tell me which database i am logged into?
>
> --
> Thanks lots
>
>
Received on Sat Apr 13 2002 - 10:24:06 CDT