Re: SELECT Question
Date: Tue, 17 Jun 2008 21:20:54 +0200
> 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 BortelReceived on Tue Jun 17 2008 - 14:20:54 CDT