Re: show user command useful in sqlplus

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.

If you're using SQL*Net. Just issue the command !echo $TWO_TASK. If that's unset, there's a good chance you're logged in on what the SID says!

Unless you've done something like 'connect user/pass_at_A_N_Other_instance'.....

*sigh*  

> Any ideas?

None whatsoever.......8-)

-- 
Alligator Descartes 		     |  "Murder, Polis!"
descarte_at_istellar.demon.co.uk        |   		- Bud Neill	
http://halibut.datatamers.com/       |  
-------------------------------------+----------------------------------------
XDBA - An X-based database management tool for ORACLE. 
	Undergoing substantial rewrites - 0.0.2 ( Smurf )