Last month, Oracle ACEs worldwide wrote more than 300 blog posts and articles, sharing tips and tricks, insights, and knowledge on various platforms. We have highlighted some of them for you to read and enjoy, focusing on Oracle Database.
Anil Mahadev
: QuickStart to Development using Oracle Database FREE 23ai Container Images
This is a quick blogpost on setting up an Oracle 23ai FREE Container Image locally and getting started with Database Adventures with Oracle 23ai!
Flavio Manuel Sarcos Torres
: Mastering Metadata with Oracle’s DBMS_DEVELOPER in 23.7
Oracle has introduced numerous features in 23ai, with a significant focus on developers—don’t you agree? I certainly think so! Let’s take a look at some of the things Oracle has done to enhance the developer experience in this release: These features collectively aim to simplify application development, enhance performance, and provide greater flexibility in data.
Lisandro Fernigrini
: Introducing Oracle Database@Azure
Oracle Database@Azure is a multi-cloud solution offered by #Oracle and Microsoft that runs Oracle Database services available in Oracle Cloud in an Azure datacenter, allowing Azure users to take advantage of the features of Oracle databases on Oracle Cloud (OCI) plus the benefits of reduced latency, simpler administration and lower costs in a known environment.
Matt Mulvaney
: APEX 24.2 RAG Search with apex_ai – Search your Database Records
In this blog, We are going to Vectorize our EMP table by creating embeddings. We’re going to perform a Vector Search for ‘Who is the President?’. When the record comes back we’ll use Generative AI with the same question to give a natural language response.
Tim Hall
: Data Redaction (DBMS_REDACT) Enhancements in Oracle Database 23ai (23.6)
This article demonstrates a number of the enhancements to Data Redaction in Oracle Database 23ai (23.6).
Data Redaction and the DBMS_REDACT package are part of the Advanced Security Option, which is a chargeable option. Redaction is available on Autonomous Database at no extra cost. Please don’t use this unless you know you are licensed for it.
Zoran Tica
: Oracle Database – Foreign Key Constraints and mutating Triggers
If You have foreign keys in your database (and chances are huge, if You’re using a relational database like Oracle properly) which have ON DELETE CASCADE or ON DELETE SET NULL set, be aware that cascade deletion or records or setting a null value is also activating table triggers on child tables.
You can find all the ACEs above and many more on the Oracle ACE Directory. Bookmark the Oracle ACE Program blog and come back next month for more updates!
