The blog post discusses PL/SQL fundamentals, focusing on cursors for retrieving multiple rows of data. It explains how to declare a cursor, use OPEN, FETCH, and CLOSE statements, and contrasts using a basic loop with a cursor for loop. Cursor attributes for managing cursor status are also covered.
ora
Oracle PL/SQL: Conditional Statements
In PL/SQL, conditional statements allow developers to control the flow of code by executing specific parts of logic based upon certain criteria, or conditions. Conditional logic is another fundamental building block. In this post, I will cover the various PL/SQL conditional statements in detail with the help of examples to illustrate how to use each conditional statement. This post is part of my PL/SQL fundamentals series.
Oracle PL/SQL: LOOPs Explained
This post explains the various types of loops in Oracle PL/SQL, including Basic, While, For, and Cursor For loops. Each type is described with syntax and examples. Understanding the correct use of these loops enhances code efficiency and maintainability, providing developers with essential tools for executing repeated operations.
Oracle PL/SQL: GROUP BY
I recently wrote, HERE, how I regularly see commonly asked questions appearing in forums relating to the same topic. Like with SELECT INTO from my previous posts, I also see lots of questions about the correct usage of the GROUP BY clause and so I figured that I would write up an explanation of how to properly use this and then, again, I can reference this post's URL in response to questions on this topic!