RE: running os command from pl/sql block
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>, "Stephane Faroult" <sfaroult@xxxxxxxxxxxx>
- Date: Wed, 1 Feb 2006 07:42:21 -0500
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
Other related posts:
