Re: The OS name of the server from PLSQL ?

From: Mark Fisher <fisherm_at_britannic.nospam.co.uk>
Date: Mon, 26 Oct 1998 13:50:01 -0000
Message-ID: <711ukp$2qu$1@soap.news.pipex.net>

Yes this works with Oracle 8.04 on NT too.

Mark Fisher
Technical Specialist
Britannic Assurance

John P. Higgins wrote in message <3630CD68.2A72CC3E_at_deere.com>...
>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 Mon Oct 26 1998 - 07:50:01 CST