See this asktom thread for discussion about that: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1288401763279 Gints Plivna http://www.gplivna.eu 2008/10/30 Charles Schultz <sacrophyte@xxxxxxxxx>: > Good day, list, > > We have had several sql issues come up that I am sure a pure Application DBA > could tackle readily. In general, what are the recognized "best ways" to > code a part of an application that has a dynamic number of predicates? <skipped> -- //www.freelists.org/webpage/oracle-l