Getting Database Name from SQLPlus
From: Glenn Travis <gtravis_at_richmond.infi.net>
Date: 24 Mar 1995 15:36:04 GMT
Message-ID: <3kuot4$21k_at_lucy.infi.net>
Date: 24 Mar 1995 15:36:04 GMT
Message-ID: <3kuot4$21k_at_lucy.infi.net>
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
Received on Fri Mar 24 1995 - 16:36:04 CET