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: Ronald Rood <devnull_at_ronr.nl>
Date: 27 Apr 2004 06:12:23 -0700
Message-ID: <67ce88e7.0404270512.186455bd@posting.google.com>


avanrossem_at_hotmail.com (Andre) wrote in message news:<4d32d1be.0404262122.6ae83050_at_posting.google.com>...
> 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?

Sure there is: look at v$database columns platform_id and platform_name, if you are running 10g.

groeten,
Ronald.



http://ronr.nl/unix-dba Received on Tue Apr 27 2004 - 08:12:23 CDT

Original text of this message

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