Re: The OS name of the server from PLSQL ?

From: John P. Higgins <jh33378_at_deere.com>
Date: 1998/10/23
Message-ID: <3630CD68.2A72CC3E@deere.com>#1/1

Try the v$session table. Look at the MACHINE column in a row where the TYPE = 'BACKGROUND'. This works on HP-UX. I don't have an NT to try it on.

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