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.
sql
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 Autonomous Database: Securing with Access Control Lists (ACL)
Access Control Lists (ACLs) enhance the security of Oracle Autonomous Database by restricting access to specific IP addresses or CIDR blocks. Users can configure ACLs during provisioning or update existing instances. This guide provides step-by-step instructions for both creating a new database and modifying an existing one to optimize security.
Oracle Database 23c Free – Developer Release: Installing & Using VirtualBox Appliance
I recently wrote about the announcement of Oracle Database 23c Free Developer Release. In this post I will provide step-by-step instructions to install Oracle Database 23c Free Developer Release using the VirtualBox Appliance provided by the Oracle product development team. Using this method, they have made it very easy to quickly get started!
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!
Oracle PL/SQL: SELECT INTO
Like many in the Oracle community, I occasionally find myself looking through forums and helping out where I can. I consistently see some basic questions cropping up in forums like StackOverflow, often the same question over and over again - one of which is regarding the "SELECT INTO" statement. I have found myself writing responses to questions about SELECT INTO statements many times and so I figured that I would write up an explanation of how to properly use this and then I can reference this post's URL in response to questions on this topic! Side note: It's been quite some time that I used PL/SQL and really enjoyed spinning up an oracle database in my free tier account and writing this post - perhaps expect a few more similar style posts alongside my usual content (maybe more commonly asked forum topics)