RE:Getting Database Name from SQLPlus
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