plsql.md

Bookmarks tagged [plsql]

^{www.codever.land/bookmarks/t/plsql}

Bulk Processing with BULK COLLECT and FORALL

^{https://blogs.oracle.com/oraclemagazine/bulk-processing-with-bulk-collect-and-forall}

In this article, I will cover the two most important of these features: BULK COLLECT and FORALL.

• BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed ...
• 📆 published on: 2012-10-01
• tags: oracle, plsql, performance, optimization

---

On Cursor FOR Loops | Oracle Magazine

^{https://blogs.oracle.com/oraclemagazine/on-cursor-for-loops}

It’s important to know when not to use cursor FOR loops. Set of recommendations about cursor FOR loops.

• Never use a cursor FOR loop if the loop body executes non-query data manipulation language (DM...
• tags: oracle, plsql

---

Working with Cursors | Oracle Magazine

^{https://blogs.oracle.com/oraclemagazine/working-with-cursors}

This article focuses on the most-common ways programmers execute SELECT statements in PL/SQL, namely

• Using the SELECT-INTO statement
• Fetching from an explicit cursor
• Using a cursor FOR loop
• Us...
• 📆 published on: 2013-04-10
• tags: oracle, plsql

---