Example 10-4: PL/SQL FOR loop with a cursor

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