Re: Another rotten query

From: <johnbhurley_at_sbcglobal.net>
Date: Fri, 20 Feb 2009 07:06:54 -0800 (PST)
Message-ID: <0e7cc9b6-f169-4c63-854f-5fc487857814_at_u1g2000vbb.googlegroups.com>

On Feb 20, 9:11 am, Mtek <m..._at_mtekusa.com> wrote:

snip

> 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