Re: Novice: Retrieve Service Name

hi

connect as system and type

select name,value from v$parameter where name like 'service%';

should do it

Alistair

"dsmcd" <lookingglass_at_stopspamdormouse.net> wrote in message news:YYGi9.13$K%.39276_at_news.uswest.net...
> Hello...
>
> Is there any way to retrieve the service name used to
> connect to the current instance?
>
> Thx,
> D.
>
Received on Fri Sep 20 2002 - 10:19:14 CDT