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

"Glen A Stromquist" <gstrom_at_nosppamtelusplanet.net> wrote in message news:<q4Yt8.10421$6G4.218921_at_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

Hi Glen,
I am trying to find out since long how to configure this glogin.sql file.
I would like to my database name,user name,database version to display in my sql prompt. Like

db_name$user_at_db_version

Thanks for the help.

Regards.
Irfan
>
> 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 Sun Apr 14 2002 - 05:25:41 CDT