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

From: James Williams <willjamu_at_mindspring.com>
Date: Sat, 13 Apr 2002 23:33:58 GMT
Message-ID: <3cb8c031.76653927@nntp.mindspring.com>

If you have enough authorization you can use select * from v$instance or show parameter db are two ways.

On Sat, 13 Apr 2002 14:40:04 +0100, "Max Adams" <RubberDucky703_at_hotmail.com> wrote:

>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 - 18:33:58 CDT

This message: [ Message body ]
Next message: Howard J. Rogers: "Re: help: how do you rename a primary key"
Previous message: James Williams: "Re: Composite index question"
In reply to: Max Adams: "How can I find out which database i'm currently in?"
Next in thread: Frank Zaum: "Re: How can I find out which database i'm currently in?"
Reply: Frank Zaum: "Re: How can I find out which database i'm currently in?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US