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.
Oracle DB
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 Autonomous Database: Load Data from Object Storage
In this post we will look at Oracle Autonomous Database, specifically the data load from object storage feature of "database actions" including how to access this feature and how to use it! This data loading feature is really simple to use allowing you to efficiently create tables or update existing tables with data that you might have stored in the cloud, all without writing any code.
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 Database 23c FREE – Developer Release
Oracle have (at the regional Oracle CloudWorld event in Singapore) just announced Oracle Database 23c Free Developer Release. If you are familiar with Oracle Database, you will know all about Oracle Database XE. This announcement is effectively a replacement of what would have been Oracle XE 23, built and made available with developers in mind. Ultimately, this new offering gives developers "early access" to build new applications, enhance or upgrade existing applications using all of the new features that 23c offers.
Oracle Integration: Connecting to Autonomous Database OOTB using Adapters
Oracle Integration Cloud comes with a library of adapters for both Oracle and 3rd Party applications. All of these capabilities mean that it’s possible to integrate applications faster and increase business agility. I've been writing a lot lately on the topic of Oracle Autonomous Database and also presenting about Oracle Integration Cloud, so I thought, why not merge the 2 subjects and document here how you might go about using the Oracle Integration out-of-the-box adapters to integrate to an Oracle Autonomous Transaction Processing (ATP) or Autonomous Data Warehouse (ADW) instance (both Oracle Autonomous Database - ADB - offerings). In this post I will describe how to use the Oracle Autonomous Database adapter in Oracle Integration Cloud to directly connect to an ATP or ADW instance.
Oracle Autonomous Database: Load Data from a Local File
In this post we will look at the data load from local file feature of "database actions" including how to access this feature and how to use it! This data loading feature is really simple to use allowing you to efficiently create tables or update existing tables with data that you might have stored locally or in the cloud, all without writing any code.
Oracle Autonomous Database: Accessing & Using Database Actions
Database actions can be accessed for Oracle Autonomous Database. In this post we will look at what Database Actions are, how to access/use them and also how to grant access to other users to make the most out of the features available.