|
[oracle-l]
||
[Date Prev]
[02-2006 Date Index]
[Date Next]
||
[Thread Prev]
[02-2006 Thread Index]
[Thread Next]
Re: running os command from pl/sql block
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- Date: Wed, 1 Feb 2006 11:05:21 +0000
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@xxxxxxxxxxxx> wrote:
>
>
> Good one. I learned something new today.
>
>
>
|
|
