First page Back Continue Last page Graphics

Comparing Join View Queries with View Links


Notes:

Comparing Join View Queries with View Links

A join view query for the example in the previous slide may be as follows:

SELECT Orders.ORDER_ID, Orders.ORDER_DATE, Persons.PERSON_ID, Persons.FIRST_NAME, Persons.LAST_NAME FROM PERSONS Persons, ORDERS Orders WHERE Persons.PERSON_ID = Orders.CUSTOMER_ID

A query for a view link uses a bind variable in a WHERE clause that is appended to the base query for the source or destination view object. In the example in the previous slide, the WHERE clause that is appended would be something like the following:

:Bind_PersonId = Orders.CUSTOMER_ID

This would query all the orders for the current customer, displaying orders and customers in a master–detail fashion.