Oracle Magazine, September/October 2018
Database Developer PL SQL ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 55 BEGIN With a static SQL statement OPEN l_ cursor FOR SELECT FROM stocks LOOP FETCH l_ cursor INTO l_ stock EXIT WHEN l_ cursor NOTFOUND END LOOP CLOSE l_ cursor Or with a dynamic SQL statement OPEN l_ cursor FOR select from stocks LOOP FETCH l_ cursor INTO l_ stock EXIT WHEN l_ cursor NOTFOUND END LOOP CLOSE l_ cursor END
You must have JavaScript enabled to view digital editions.