RE: running os command from pl/sql block

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 1 Feb 2006 07:42:21 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF27069D40D3@AABO-EXCHANGE02.bos.il.pqe>

Yeah, my Solaris 9 looks a bit odd as well.....  

devora2_(dvl1)$sqlplus mbobak_at_dvl1 <mailto:mbobak_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples
Sent: Wednesday, February 01, 2006 6:05 AM
To: Stephane Faroult
Cc: onkarnath.tiwary_at_gmail.com; gorbyx_at_gmail.com; 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_at_roughsea.com> wrote: 


	Good one. I learned something new today.
	
	
	






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

Received on Wed Feb 01 2006 - 06:42:21 CST