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.
database
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.
NEW FEATURES in Oracle Integration 3! (26.01)
In January 2026, Oracle Integration 3 v26.1 was released, introducing numerous new features. Key additions include enhanced disaster recovery, new integration capabilities with AI, and upgraded agents. The release also features new and updated connectivity adapters to improve functionality and support advanced use cases.
NEW FEATURES in Oracle Integration 3! (25.10)
In October 2025, Oracle Integration 3 v25.10 introduced new features, including enhanced disaster recovery, AI-driven project creation, and improved adapters. This release marks Oracle's 1st ever quarterly release for Oracle integration . Key enhancements involve expanded regional availability, better monitoring, and streamlined integrations, contributing to a more robust user experience.
NEW FEATURES in Oracle Integration 3! (25.06)
In June 2025, Oracle Integration 3 v25.06 was released, introducing numerous new features including enhanced disaster recovery, and various integration recipes. The update also incorporates an array of AI capabilities along with new and improved out of the box adapters
NEW FEATURES in Oracle Integration 3! (25.04)
In April 2025, Oracle Integration 3 v25.04 was released, introducing numerous new features, including an announcements banner, enhanced disaster recovery, and various integration recipes. The update also incorporates AI capabilities for document processing and SQL queries, along with new and improved adapters for OAuth security and other connectivity enhancements.
NEW FEATURES in Oracle Integration 3! (25.02)
In February 2025, Oracle Integration 3 v25.02 was released, introducing several new features including Robotic Process Automation, enhanced disaster recovery, and a component-usage-based billing model. Additionally, new integration recipes, improvements to project functionalities and dashboards, and updated out-of-the-box adapters were launched to enhance connectivity and integration capabilities.