DECLARE CURSOR stock_cur IS SELECT s.address,s.salary FROM customers s; stock_rec stock_cur%rowtype; BEGIN FOR stock_rec in stock_cur LOOP dbms_output.put_line('Company : ' || stock_rec.company || '- Current Price : ' || stock_rec_price); END LOOP; END;