Re: Connection info in SQLPlus?

From: Fred Pierce <fpierce_at_avialantic.com>
Date: 1998/01/16
Message-ID: <34BF5111.41C6_at_avialantic.com>#1/1


> Is it possible to get the service I'm connected to in SQL*Plus?
> When I connect like this:
>
> connect scott/tiger_at_my_db
>
> I can get the name of the current user 'scott' using
>
> show user
>
> But how can I get 'my_db'?

select name from v$database;

fdp



 Fred Pierce - QSS Group Inc. Oracle DBA (301) 286-6899    fpierce_at_nssdc.gsfc.nasa.gov fpierce_at_avialantic.com   Mid Atlantic Aviation on the Web - www.avialantic.com  MAAM WWII Commemorative Weekend June 5-7 /maamwwii.html
Received on Fri Jan 16 1998 - 00:00:00 CET

Original text of this message