Re: Getting Database Name from SQLPlus
From: Dave Crowson <dcrowson_at_amoco.com>
Date: Fri, 24 Mar 1995 16:29:57
Message-ID: <dcrowson.1292.00108046_at_amoco.com>
Date: Fri, 24 Mar 1995 16:29:57
Message-ID: <dcrowson.1292.00108046_at_amoco.com>
In article <3kuot4$21k_at_lucy.infi.net> gtravis_at_richmond.infi.net (Glenn Travis) writes:
>Is there a way to select the database name in query while using SQLPlus?
Yup, there sure is;
select value
from sys.v_$parameter
where name ='db_name'
/
David Crowson Oracle Consultant (since '83) igotan_at_ombomb.demon.co.uk weirdguy_at_cix.compulink.co.uk'Hit them in the Face, with a Funky Bass, for a Happy Smiling Race' Received on Fri Mar 24 1995 - 16:29:57 CET