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>


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

Original text of this message