Example 10-5: PL/SQL FOR loop with a cursor and bind variables

DECLARE
  CURSOR c_BigMovers (cp_Symbol VARCHAR2 DEFAULT '%')
      IS SELECT symbol, price, change
           FROM quotes
          WHERE change > 3.00
            AND symbol LIKE '%'||cp_Symbol||'%';
BEGIN
  FOR curQuote IN c_BigMovers('ORCL')
  LOOP
    DBMS_OUTPUT.PUT_LINE(' Symbol: '||curQuote.symbol||
                         '  Price: '||curQuote.price ||
                         ' Change: '||curQuote.change);
  END LOOP;
END;