Re: Another rotten query

From: <>
Date: Fri, 20 Feb 2009 07:06:54 -0800 (PST)
Message-ID: <>

On Feb 20, 9:11 am, Mtek <> wrote:


> Hpuxrac,
> We are on 10gR2.  I was thinking about some analytical queries and
> such.......

It sounds like you are just reporting. In general if you can put together a plsql procedure that drives somehow a set of related queries ... you may very well be able to do it in a single SQL statement.

That's the approach I would recommend you take a swing at first before falling back and doing it in plsql. Received on Fri Feb 20 2009 - 09:06:54 CST

Original text of this message