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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Easy-to-Answer Question from Newbie

Re: Easy-to-Answer Question from Newbie

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 5 Jan 2003 13:44:35 -0000
Message-ID: <3e1836c6$0$225$cc9e4d1f@news.dial.pipex.com>


"padderz" <member633_at_dbforums.com> wrote in message news:2348122.1041709193_at_dbforums.com...
>
> ..run in what sense? As in get some data? To test performance?
>
> A casual look at v$mystat and I'd guess it doesn't do *anything*
> beyond parsing.

I'm afraid I got rather irritated by the original post (the code in which also was intended to do nothing useful). So I posted a reply which did exactly what the OP was trying to code, without commenting helpfully as others have done about selecting into something or the use of ref cursors etc. This was not helpful and I apologize.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sun Jan 05 2003 - 07:44:35 CST

Original text of this message

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