Understanding the Model Layer - Oracle ADF 11gR2 Development Beginner's Guide - page 87

At most one Row : This opion can be used to get at the most one row when the
view object query is executed.
No rows : This opion can be used retrieve a no rows event ater querying the
database using the view object.
Query Opimizer hints : This opion provides an opimizer hint to make the view
object performant in retrieving the data.
Fill last page of rows : This opion will display the result of the query when working
with paginaion in the UI. Paginaion is displaying the result of the query in pages,
with a range of data.
Passivate State : This opion is used to maintain the state of the object on failover
by passivaing the view object collecion data. This opion is used in a clustered
environment, where the acivaion and passivaion of query results is mandatory
for the highly available applicaion.
Access Mode : This seing provides opions to support paginaion in the UI.
Range size : This opion deines the range size of the rows in each paging view.
Entity Objects
The view object is created based on the enity that you will select. The view object can be
based on muliple enity objects, using joins.
Attributes
The Atributes secion deines the following properies:
SDO Property : Someimes, a view object is used as a service. Check if this is acing
as a service deiniion object.
XSD Type : This opion deines the XML Schema Deiniion (XSD) type to be used
for a service deiniion.
List of Values
You can use this seing to provide a list to be shown for the atribute in the UI.
Query
The SQL query deined for the view object is shown in this secion. We can change
the Where: and the Order by: clause in this secion, if the view object is based on
an enity object.