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

["Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>]

Yeah, my Solaris 9 looks a bit odd as well.....
 
devora2_(dvl1)$sqlplus mbobak@dvl1 <mailto:mbobak@dvl1> 
 
SQL*Plus: Release 9.2.0.7.0 - Production on Wed Feb 1 07:41:03 2006
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Enter password:
 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning and OLAP options
JServer Release 9.2.0.7.0 - Production
 
SQL> select dbms_utility.port_string from dual;
 
PORT_STRING
------------------------------------------------------------------------
--------
SVR4-be-64bit-8.1.0
 
SQL> !uname -a
SunOS devora2 5.9 Generic_118558-14 sun4u sparc SUNW,Ultra-80

 

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

"There are 10 types of people in the world:  Those who understand
binary, and those who don't." 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples
Sent: Wednesday, February 01, 2006 6:05 AM
To: Stephane Faroult
Cc: onkarnath.tiwary@xxxxxxxxx; gorbyx@xxxxxxxxx; ORACLE-L
Subject: 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
-----------------------
Windows XP Professional

On 2/1/06, Stephane Faroult <sfaroult@xxxxxxxxxxxx> wrote: 


        Good one. I learned something new today.
        
        
        


BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD