RE: Platform

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 26 Sep 2001 09:01:49 -0700
Message-ID: <F001.00399606.20010926091023@fatcity.com>

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_at_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?
Received on Wed Sep 26 2001 - 11:01:49 CDT