Re: Creating query based on results of a query...

On Wed, 30 Jun 2004 17:08:26 +0200, "CloudsŪ" <DOCloudsNOT_at_hardwareSPAM-spot.com> wrote:

>I guess this is not possible with plain SQL....

It is definitely possible with plain sql. Either set up a static view
create view abc as <your original select>

select * from abc where

or (usually performs better) set up an inline view

select * from
(<your original select>)
where etc.

Don't resort to 'temp' tables, in Oracle you only rarely need them.

--
Sybrand Bakker, Senior Oracle DBA