Re: running os command from pl/sql block

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@xxxxxxxxxxxxxxx> wrote:
>
> Yeah, my Solaris 9 looks a bit odd as well.....
>
> devora2_(dvl1)$sqlplus 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.
> >
> >
> >
>
>


--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
       to_onkar@xxxxxxxxx
       onkarnath.tiwary@xxxxxxxxx

Other related posts: