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 DB
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.
Connecting to an ATP Database in Oracle Cloud
In this post, I document the steps to help you to connect to (and use!) a newly created Oracle ATP Database Service
Creating an ATP Database in Oracle Cloud
In this post, I document the steps to help you create your own Oracle ATP Database Service.
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!
AMY SIMPSON-GRANGE - BLOG 