Re: Getting the name of the database

From: Michael Olin <molin_at_bmgdirect.com>
Date: Tue, 21 Jul 1998 13:09:29 -0400
Message-ID: <35B4CB47.609F0A64@bmgdirect.com>

calberto_at_my-dejanews.com wrote:

> Hi all!
>
> Is there any function in Oracle that returns the name of the database I am
> using like there is SELECT USER FROM DUAL to get the username?
>
> Thanks in advanced,
>
> Carlos

Try SELECT * FROM GLOBAL_NAME

-Michael Received on Tue Jul 21 1998 - 12:09:29 CDT

This message: [ Message body ]
Next message: Arjan van Bentem: "Re: PL/SQL package to create tables and/or triggers"
Previous message: Joel Garry: "Re: Help about develop in character mode with Oracle 7.3 and Forms 3.0 and RPT"
In reply to: calberto_at_my-dejanews.com: "Getting the name of the database"
Next in thread: poohland_at_my-dejanews.com: "Re: Getting the name of the database"
Reply: poohland_at_my-dejanews.com: "Re: Getting the name of the database"

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