Re: SELECT Question

Mtek wrote:

> WHERE ol.order_id = co.order_id
> AND ol.product_id = p.product_id
> AND ol.order_item_id = z.order_item_id(+)
> AND p.type = 3
> AND co.order_id IN (............)
> AND co.customer_id = p_customer_id;
>
> I will need to loop through this CURSOR or SELECT many times. And,
> the IN clause goes where the ........ are located.
>
> So, is all of this supposed to use an EXECUTE IMMEDIATE statement?
> Can I loop using that???

As others tried to tell you: DON'T!

Consider a global temporary table, and you that. IN lists are bugger anyway

-- 

Regards,
Frank van Bortel