Re: show user command useful in sqlplus
From: Yves Noel <noel_at_omega.univ-lille1.fr>
Date: 26 Sep 1994 08:47:14 GMT
Message-ID: <3661qi$t8g_at_netserver.univ-lille1.fr>
Date: 26 Sep 1994 08:47:14 GMT
Message-ID: <3661qi$t8g_at_netserver.univ-lille1.fr>
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?
|>
Yes, you connect as SYS under SQLPLUS and : select ksqdngdn from x$ksqdn;
-- Yves NOEL (Administrateur bases de donnees) C.I.T.I. (batiment M4) Mail: Yves.Noel_at_univ-lille1.fr Universite des Sciences & Technologies Tel : +33 20.33.70.74 59655 Villeneuve d'Ascq Cedex - FRANCE Fax : +33 20.43.66.25Received on Mon Sep 26 1994 - 09:47:14 CET