Re: how to get database name using sql statements

From: Fritz <fritz_nospam_at_mail4u.nl>
Date: Thu, 25 Nov 1999 14:43:18 +0100
Message-ID: <81jbo9$cdc$1@news1.xs4all.nl>

Try 'Select * from v$database'

Regards...

Praburam Conjeevaram wrote in message ...
>
>I am new to oracle db.
>I am using sql plus to try sql commands.
>can someone tell me how to get the dbname to which i am connected.
>note:I am able to select records from tables
>Thanks
>
>-Prabu
>
>
>
>
>
>
>
>
Received on Thu Nov 25 1999 - 07:43:18 CST

This message: [ Message body ]
Next message: Biagio Scognamiglio: "Obfuscate PL/SQL code"
Previous message: Pete Kolton: "Re: Forms 4.5 - Unique Records"
In reply to: Praburam Conjeevaram: "how to get database name using sql statements"
Next in thread: Noodles: "Re: how to get database name using sql statements"
Reply: Noodles: "Re: how to get database name using sql statements"

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