Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine current connect string?
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 |
-- ------------------------------- Konstantin V. Sartakov Kuzbassprombank Kemerovo Russia mailto:skv_at_kpbank.ruReceived on Tue Apr 08 1997 - 00:00:00 CDT