Re: PLSQL & dyn generating sql (& oracle forms)

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 11 Dec 2002 13:25:19 -0800
Message-ID: <1b061893.0212111325.702718b6_at_posting.google.com>


If I were you, I'd create a 1-column nested table, and use it in my select statement this way:

cursor c1 is
select *
from table
where field in (select my_only_field from my_nested_table);

Or even better performance-wise, use an EXISTS clause instead of an IN clause.

HTH Daniel Received on Wed Dec 11 2002 - 22:25:19 CET

Original text of this message