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; |