Re: show user command useful in sqlplus
From: Peter Sterne <pete_at_greenwich.com>
Date: Tue, 27 Sep 1994 19:29:51 GMT
Message-ID: <1994Sep27.192951.28810_at_greenwich.com>
Date: Tue, 27 Sep 1994 19:29:51 GMT
Message-ID: <1994Sep27.192951.28810_at_greenwich.com>
In article <CwnMFJ.C93_at_freenet.carleton.ca> ag831_at_FreeNet.Carleton.CA (Denis Langlais) writes:
>
>I find the "show user" command in sqlplus useful
>to tell me what I'm logged on as. However it would
>be nice to have a show dbname command to tell
>me what database I'm logged on. I know in
>unix that you can issue !echo $ORACLE_SID but this
>may not be reliable if your using sqlnet to another host.
>
>Any ideas?
I believe that the statement 'Select * from global_name;' will return the name of the data base to which you are connected.
Regards,
-- Peter Sterne, Sr. Programmer/Analyst Greenwich Associates, Greenwich Connecticut pete_at_greenwich.com, voice (203)625-5089, fax (203)629-1229Received on Tue Sep 27 1994 - 20:29:51 CET