DECLARE CURSOR stock_cur IS SELECT c.address,c.salary FROM customers c; stock_rec stock_cur%rowtype; BEGIN IF NOT stock_cur%ISOPEN THEN OPEN stock_cur; END IF; LOOP FETCH stock_cur INTO stock_rec; EXIT WHEN stock_cur%NOTFOUND; dbms_output.put_line('Address ' || stock_rec.address || ' - Current Salary : ' || stock_rec.salary); END LOOP; CLOSE stock_cur; 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