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.
Month: May 2026
Oracle AI: Are Enterprises Entering a New Chapter?
The post discusses the evolution of enterprise technology, particularly the shift towards AI-driven SaaS solutions. It questions whether current enterprises can keep pace in a volatile environment and highlights Oracle's recent innovations, such as AI-native applications and databases, aiming to enhance efficiency, decision-making, and security in operations.
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.
NEW FEATURES in Oracle Integration 3! (26.04)
In April 2026, Oracle Integration released version 3 26.04, introducing numerous new and updated features, including new service metrics, integration recipes, and enhanced agentic AI functionalities. Key updates include support for various models and improved adapters for seamless connectivity. This release marks Oracle's second of the year in its quarterly cycle.
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.