Re: running os command from pl/sql block

From: Kevin Lidh <kevin.lidh_at_gmail.com>
Date: Thu, 2 Feb 2006 07:34:27 -0700
Message-ID: <cb4807f0602020634j2f621ebbg4f7053271e44ba58@mail.gmail.com>

I haven't seen this one in the list yet but I have:

 select dbms_utility.port_string from dual;

PORT_STRING

---

x86_64/Linux 2.4.xx

Which is interesting since I'm at the 2.6 kernel. Ah well, what Oracle doesn't know...

Kevin

On 2/2/06, Herring Dave - dherri <Dave.Herring_at_acxiom.com> wrote:
>
> Okay, I'll jump in from the non-Linux world:
>
> PORT_STRING
> ------------------------------------------------------------------------
> ------------------------------------------------------------
> DEC Alpha OSF/1, r1.1-8.1.0
>
> % uname -a
> OSF1 V5.1 2650 alpha
>
> Its nice to see DEC is still mentioned after Compaq and HP did their
> purchases. You think Oracle admits anywhere internally optimizer logic
> they took from Rdb? :-)
>
> Dave
> -------------------------------------
> Dave Herring, DBA
> Acxiom Corporation
> 3333 Finley
> Downers Grove, IL 60515
> wk: 630.944.4762
> <mailto:dherri_at_acxiom.com>
> -------------------------------------
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> > On Behalf Of Mladen Gogala
> > Sent: Wednesday, February 01, 2006 6:54 AM
> > To: Mark.Bobak_at_il.proquest.com
> > Cc: davidsharples_at_gmail.com; Stephane Faroult;
> onkarnath.tiwary_at_gmail.com;
> > gorbyx_at_gmail.com; ORACLE-L
> > Subject: Re: running os command from pl/sql block
> >
> > When everybody is publishing port string, let me join the fray:
> >
> > SQL> select dbms_utility.port_string from dual;
> >
> > PORT_STRING
> >
> ------------------------------------------------------------------------
> --
> > ------
> > Linuxi386/Linux-2.0.34-8.1.0
> >
> > SQL>
> >
> > It doesn't even say "IBMPC".
> >
> > --
> > Mladen Gogala
> > http://www.mgogala.com
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
>
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
>
> ****************************************************************************
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Thu Feb 02 2006 - 08:34:27 CST