Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine current connect string?

Re: How to determine current connect string?

From: Konstantin V Sartakov <skv_at_kpbank.ru>
Date: 1997/04/08
Message-ID: <33499886.6125@kpbank.ru>#1/1

Hi
In SQL*Menu v5 you can use combination of predefined parameters &un/&pw ...
vermaat_at_gemini.tfdl.agro.nl wrote:
>
> In article <53967.adizon_at_mail.us.net>, <adizon_at_mail.us.net> writes:
> >I know that 'select user from dual' returns the current user id. How do I
> >return the current connect string?
> >
> >Thanks,
> >Lito
> >
> >Lito Dizon
> >adizon_at_us.net
> >
>
> The only thing I can come up with is the name of the database you are currently
> connected with:
>
> SELECT global_name FROM global_name;
>
> which will return [database name].WORLD .
>
> ********************************************************************************
> | Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |



> | p.j.r.vermaat@fd.agro.nl | http://www.agro.nl/~vermaat/ |


> | Flagellant in Dreamland |
> ********************************************************************************
 regards
-- 
-------------------------------
         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
           mailto:skv_at_kpbank.ru
Received on Tue Apr 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US