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;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter