Oracle JDeveloper 11gR2 Cookbook

Chapter 3. A Different Point of View: View Object Techniques

In this chapter, we will cover:

• Iterating a view object using a secondary rowset iterator
• Setting default values for view row attributes
• Controlling the updatability of view object attributes programmatically
• Setting the Queryable property of a view object attribute programmatically
• Using a transient attribute to indicate a new view object row
• Conditionally inserting new rows at the end of a rowset
• Using findAndSetCurrentRowByKey() to set the view object currency
• Restoring the current row after a transaction rollback
• Dynamically changing the WHERE clause of the view object query
• Removing a row from a rowset without deleting it from the database

Introduction

View objects are ...