Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: running os command from pl/sql block
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 01 2006 - 05:05:21 CST
![]() |
![]() |