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