FreeLists / oracle-l / Re: running os command from pl/sql block

[Stephane Faroult <sfaroult@xxxxxxxxxxxx>]

David Sharples wrote:

> SQL> select dbms_utility.port_string from dual;
>
> PORT_STRING
> --------------------------------------------------------------------------------
> Linuxi386/Linux-2.0.34-8.1.0
>
>
>
> On 2/1/06, *Stephane Faroult* <sfaroult@xxxxxxxxxxxx 
> <mailto:sfaroult@xxxxxxxxxxxx>> wrote:
>
>         The only place I know where you can get the OS is V$VERSION, where
>     banner like 'TNS%'. Unfortunately, you won't get the exact
>     version, but
>     it can be enough if all you want is differentiate Windows from various
>     Unix flavours.

Good one. I learned something new today.

Stéphane Faroult

--
http://www.freelists.org/webpage/oracle-l