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:[EMAIL PROTECTED]]
>
> 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?