Re: find out os from pl/sql

From: Radoulov, Dimitre <_at_>
Date: Wed, 18 Oct 2006 15:46:22 +0200
Message-ID: <4536302d$0$49209$14726298@news.sunsite.dk>

"Loial" <admin_at_loial.co.uk> wrote in message news:1161173211.505459.159290_at_e3g2000cwe.googlegroups.com...
> Is there any table I can query to find out the operating
> system(Linux/AIX etc) from pl/sql?

Check dbms_utility.port_string.

On RH:

SQL> select dbms_utility.port_string from dual;

PORT_STRING

---

Linuxi386/Linux-2.0.34-8.1.0

On Solaris:

SQL> select dbms_utility.port_string from dual;

PORT_STRING

---

SVR4-be-64bit-8.1.0

Regards
Dimitre Received on Wed Oct 18 2006 - 08:46:22 CDT