First page Back Continue Last page Text

oracle adf workshop


Restricting the Rows Retrieved by a Query

One way to restrict the rows retrieved by a query is to set a WHERE clause on the query panel of the view object editor. To invoke the Edit Query dialog box, click Edit (pencil icon) in the Query section of the panel. You can hard code the value for the WHERE clause, or you can use a bind variable as described in “Using Named Bind Variables,” later in this lesson.