Radoulov, Dimitre wrote:
> "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
Also:
SELECT * FROM gv$version;
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Oct 18 2006 - 10:22:32 CDT
