Re: running os command from pl/sql block

  • From: Kevin Lidh <kevin.lidh@xxxxxxxxx>
  • To: Dave.Herring@xxxxxxxxxx
  • Date: Thu, 2 Feb 2006 07:34:27 -0700

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@xxxxxxxxxx> 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@xxxxxxxxxx>
> -------------------------------------
>
> > -----Original Message-----
> > From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > On Behalf Of Mladen Gogala
> > Sent: Wednesday, February 01, 2006 6:54 AM
> > To: Mark.Bobak@xxxxxxxxxxxxxxx
> > Cc: davidsharples@xxxxxxxxx; Stephane Faroult;
> onkarnath.tiwary@xxxxxxxxx;
> > gorbyx@xxxxxxxxx; 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
> >
> > --
> > //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.
>
> ****************************************************************************
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: