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.