Year: 2023
-
Cursor Basics: Cursor Iteration Controls
In the previous post we discussed the use of bulk collect and limit to optimize cursor iteration. This gave us a way to see the undocumented bulk prefetch optimization that has been applied…
-
Cursor Basics: Bulk Binds
In the previous post we discussed the most basic approaches to iterating through a resultset using cursors. Since those approaches traverse the cursor one row at a time they are often referred to…
-
Cursor Basics: A Fetching Difference
There are some techniques that are really basic to what we do everyday as PL/SQL developers. There is a tendency to automatically do these basic things in the same way without considering the…
-
Getting Started For Free
Because the intended audience for this blog is anyone that works with or wants to work with Oracle PL/SQL, from the advanced expert to the beginner, I want to take a moment before…
-
Open Source Listing Created
Hello, I am still working on getting things set up here at practicalplsql.org. While I am getting things organized, I want to bring your attention to a new resource that I have attached…
-
A Statement of Direction
Mission statement and credits for this blog.