Re: running os command from pl/sql block

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 1 Feb 2006 11:05:21 +0000
Message-ID: <be592d550602010305j3bb4079ft93f17c961e5d6887@mail.gmail.com>

slight warning

Some OS'es will appear kinda weird, would then have to use some sort of decode to make it more readable

e.g.

XP Prof
SQL> select dbms_utility.port_string from dual;

PORT_STRING

---

IBMPC/WIN_NT-8.1.0 Its not an IBM either, its a dell :-)

SQL> select decode(dbms_utility.port_string, 'IBMPC/WIN_NT-8.1.0','Windows XP Professional') from dual;

DECODE(DBMS_UTILITY.POR

---

Windows XP Professional
On 2/1/06, Stephane Faroult <sfaroult_at_roughsea.com> wrote:
>
>
> Good one. I learned something new today.
>
>
>

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

Received on Wed Feb 01 2006 - 05:05:21 CST