Results from 69 Oracle APEX AI Agent turns comparing three models, token costs, tool use, and correctness, with practical design lessons.

Background As you probably know, I’m maintaining a parser for grammars used in SQL files for Oracle AI Database and PostgreSQL. As a result, I check for new statements and clauses in every version of ...

Introduction The dbLinter clients include a new setting named Allow Insecure TLS. It is disabled by default. As a result, all REST API calls verify the TLS certificate and hostname. The setting allows...

Introduction The script command was introduced with SQLcl 4.2. It is based on JSR 223, the Java Scripting API, and makes it possible to run JavaScript from SQLcl. This adds client-side control flow, f...

Learn how SQL assertions enforce temporal integrity in Oracle AI Database by preventing overlaps and detecting gaps in temporal relationships.

Undocumented SYS_CONTEXT Parameters

Coding agents write plenty of PL/SQL, but they need a feedback loop to write it well. Here's how to hand dbLinter to Coding Agents and teach it to check its own work.

Introduction A parser for the APEXlang grammar enables the development of tools beyond the scope of the APEXlang compiler included in SQLcl, SQL Developer for VS Code, and ORDS. These tools can perfor...

Introduction The APEXlang API Reference documentation went live a few days ago. You can also download the APEXlang EBNF grammar. In this post, Kris Rice explains the value of having an EBNF. Since the...

In the last part of this blog series, we will look at how to load Slowly Changing Dimension (type SCD1 and SCD2) from the Current Views we created in our multi-temporal Data Vault schema.

A new PWOW webinar is approaching, focusing on a topic often—unfairly—neglected: Unit Testing . 🧪 The key to success isn't just wri...

Without an Anti-Corruption-Layer (ACL), direct database table access leads to tight coupling, increased risk of breakage on schema changes…

FEATURE: Most customers don't need the biggest baddest models, just ones that work, are cheap, and won't pirate their proprietary data

Three research teams found it at the same time. NVIDIA GPUs with GDDR6 can be used to take full system control, bypassing IOMMU. No fix for consumer GPUs.

YouTube video by Decomplexify

Explore SQL Assertions in Oracle AI Database and learn how to enforce hierarchy integrity by detecting cycles with declarative constraints.

Lighten or darken APEX Universal Theme colors with the mix-color function to create custom colors for your APEX applications.

Introduction More than twelve years ago, I described the multi-temporal features of Oracle Database in this blog post. In the conclusion, I wrote that I missed a temporal DML API, temporal integrity c...

25-30 years ago I worked a lot with the Danish developed ERP system called Concorde XAL. It ran on top of a database (choice of several, mos...

Introduction Referential integrity constraints have been available since version 7 of the Oracle Database. While these constraints ensure that referenced rows exist, they cannot express more complex i...

TL;DR: A simple use-case for SQL-Assertions: Adding a data-related constraint to an arc-relation. Demo using the Emp-Dept schema. Summary u...

YouTube video by Oracle Developers

After 15 years on macOS, I switched to Arch Linux with Omarchy. 8 months in, here's what replaced my Apple apps, which hardware I chose, and what actually broke — and how I fixed it.

This page describes the ora-08673 Oracle Database Error Messages, also known as ora08673, ora-8673 or ora8673

YouTube video by Oracle Developers

YouTube video by United Codes

Not too long ago, I responded to an email list regarding the storage of Oracle Database's extended VARCHAR2 data types, which allow you to store up to 32 KB of data. Because the LOB layer is used to store the data, it is often misunderstood that extended VARCHAR2s are nothing but tiny CLOBs and fall under the same semantic rules as…

The success of a project or product depends largely on the quality of the code. But how can I improve security, maintainability or performance? More importantly, how can I prevent code with quality de...

We help teams establish reliable and repeatable engineering practices around their databases, without unnecessary complexity.