Re: The OS name of the server from PLSQL ?

I don't know if it will always work, but on our system, following query gives us the name of the Oracle server:

 select machine from v$session
 where sid = (select min(sid) from v$session);

Marc Billiet

Yves DEBIZET wrote:
>
> How to retrieve the OS name of the server from PLSQL ?
>
> That would be useful in order to switch from WIN to UNIX pathnames
> replacing '\' with '/' and vice-versa.
>
> --
> Yves DEBIZET (mailto:yd_at_mc2.fr, tel: +33 0476 04 50 29, fax: +33 0476 04
> 50 01)
> MC2 (http://www.mc2.fr)
> 4 Chemin de Malacher, ZIRST 4401
> F38944 Meylan Cedex
Received on Fri Oct 23 1998 - 00:00:00 CDT