Re: running os command from pl/sql block

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: davidsharples@xxxxxxxxx
  • Date: Wed, 01 Feb 2006 12:07:25 +0100

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

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


Other related posts: