Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: running os command from pl/sql block

Re: running os command from pl/sql block

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Wed, 1 Feb 2006 18:29:52 +0530
Message-ID: <a144e5210602010459s111c53e4if84f6a2c37304fb7@mail.gmail.com>


thanx a lot everyone. now my proc is running fine with the information i was thinking of.

On 2/1/06, Bobak, Mark <Mark.Bobak_at_il.proquest.com> wrote:
>
> Yeah, my Solaris 9 looks a bit odd as well.....
>
> devora2_(dvl1)$sqlplus 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.
> >
> >
> >
>
>

--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 01 2006 - 06:59:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US