From Jacques.Kilchoer@quest.com Wed, 26 Sep 2001 09:01:49 -0700 From: Jacques Kilchoer Date: Wed, 26 Sep 2001 09:01:49 -0700 Subject: RE: Platform Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Platform I've also used this query: select substr (banner, 9, instr (banner, ':') -  9) as os from v$version where banner like 'TNS for %' ; Because port_string is sometimes cryptic. For example, on my 7.3.4 database on Sun Solaris, here's what I get: SQL> select dbms_utility.port_string from dual ; PORT_STRING ------------------------------------------------ SVR4-be-7.0.0 > -----Original Message----- > From: Libal, Ivo [mailto:ivo.libal@knapp-systems.com] > > If you are interested I found the answer on metalink: > > select dbms_utility.port_string from dual; > > -----Original Message----- > Sent: Wednesday, September 26, 2001 02:09 PM > > how is it possible in PLSQL to decide on which operating > system (NT/LINUX)is > server running? > I would like to automatically specify directory where output > from dbms_file > will go. On nt I need something like c:\log and on unix I > would like to have > something like /log  . > Is there any view where I can find this information about OS?