RE:Getting Database Name from SQLPlus

From: (wrong string) ”fer <GPONHOEF_at_Materna.DE>
Date: 1995/03/27
Message-ID: <GPONHOEF.13.2F76DA11_at_Materna.DE>#1/1


In article <3kuot4$21k_at_lucy.infi.net> gtravis_at_richmond.infi.net (Glenn Travis) writes:
>From: gtravis_at_richmond.infi.net (Glenn Travis)
>Subject: Getting Database Name from SQLPlus
>Date: 24 Mar 1995 15:36:04 GMT
 

>Is there a way to select the database name in query while using SQLPlus?
 

>I am using net to connect to different servers on different machines to
>produce dba type reports on disk usage ,etc... and would like to list the
>instance name on the header page for the reports (querie output). I can
>spool to $ORACLE_SID but can't use ORACLE_SID in the report heading.
 

>Any ideas?
>--
>Glenn Travis
>DBA
>Circuit City Stores, Inc.
>Richmond, VA USA
>gtravis_at_richmond.infi.net
>gtravis_at_aol.com

Try the oracle view "user_profiles".

Gregor Ponh(oe)fer                    Voice : +49 231 5599-243
Dr. Materna GmbH                     Fax   : +49 231 5599-100
Vosskuhle 37                       e-mail: Internet: 
Gregor.Ponhoefer_at_materna.DE44141 Dortmund, Germany Received on Mon Mar 27 1995 - 00:00:00 CEST

Original text of this message