Oracle JDeveloper 11gR2 Cookbook

Limiting large view object query result sets

In the recipe Limiting the rows fetched by a view object in this chapter, we have seen how to limit the number of rows that can be fetched from the database by a view object. While this technique limits the number of rows fetched from the database to the middle layer, it will not limit the view object query that runs in the database. In this case, a query that produces a result set in the thousands of records will still be executed, which would be detrimental to the application's performance. This recipe takes a different approach - actually limiting the view object query to a predefined row count defined by the specific view object using a custom property.

Getting ready

The recipe uses the ...