Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: - determine Operating system using pl/sql??

Re: - determine Operating system using pl/sql??

From: Herman de Boer <h.de.boer_at_YouCanGuessThis.com>
Date: Wed, 28 Apr 2004 08:59:34 +0200
Message-ID: <408f5655$0$64453$e4fe514c@news.xs4all.nl>


Andre wrote:

> Hello all,
>
> I've written a pl/sql package. Within this package I want to know if
> the Operating system on which the Database is running is UNIX or
> Windows-based.
>
> Is there a way to do this?
>
> regards,
> Anneke
> The Netherlands

Hello Anneke,

what about a simple:

select dbms_utility.port_version from dual;

-- 
Kind Regards,

Herman de Boer
sr. Consultant, IT Consultancy group bv (itcg.nl)
Received on Wed Apr 28 2004 - 01:59:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US