Iterating a view object using a secondary rowset iterator

There are times when you need to iterate through a view object rowset programmatically. In this recipe, we will see how to do this using a secondary rowset iterator. We will iterate over the Employees rowset and increase the employee's commission by a certain percentage for each employee that belongs to the Sales department.

Getting ready

This recipe was developed using the HRComponents workspace, which was created in the Overriding remove() to delete associated children entities recipe in Chapter 2, Dealing with Basics: Entity Objects. The HRComponents workspace requires a database connection to the HR schema.

How to do it...

  1. Open the Employees view object definition and go to the Java page. ...

Get Oracle JDeveloper 11gR2 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.