Figure 7: Single SQL statement processing multiple objects

DECLARE CURSOR cursor1 FOR 
SELECT c.cust_name, c.cust_address
FROM orders o, customers c
WHERE ord_date  = ‘11/03/2008’  AND
                o.custid = c.custid;
OPEN cursor1;
Do
  FETCH cursor1 INTO :v_name, v_address;
  /* Process customer data */ 
UNTIL ( no more data );
CLOSE cursor1;