To upgrade run the upgrade_packages.sql script attached to the GitHub release. This release has no migration script. For new installations follow this guide. Behavior notes: TOON output follows sp...

Oracle APEX utility commands for Alfred. Contribute to United-Codes/uc-alfred-orclapex development by creating an account on GitHub.

How a makefile turns the SQLcl, Git and dbLinter commands of an APEX project into short make commands, and how a Git-based sync script stops APEXlang imports from overwriting your colleagues' App Buil...

YouTube video by Olympic Games

Migration guide for 26.3 -> 26.4

Build practical APEX 26.1 AI Agents with tools, prompts, approvals, PL/SQL calls, and guardrails for real-world business apps.

Changing the Oracle Free image tag keeps your data but leaves the data dictionary behind. Learn how to check, and how to patch it.

Letting an LLM write one small program that calls your tools in a loop beats round-tripping every call through the model. Here is how I built that for UC AI with Oracle MLE, and why the sandbox was th...

YouTube video by United Codes

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.

Plug-and-play dockerized local Oracle APEX environment with Oracle 26ai and ORDS - United-Codes/uc-local-apex-dev

By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause. The reason I like it is that it lets you solve a problem by composing little pieces …

The new JOIN TO ONE syntax extension seems to be very useful for queries on star schemas. But before we can use it, we have to prove how they can be combined with different types of constraint defi…

YouTube video by Kai Lentit

Astro 7.0 brings faster builds with Vite 8, a new Rust compiler, Advanced Routing, background dev server support, and structured logging.

What's Changed (since first 26.2 release) Migration guide DB 23.26.1.0 → 23.26.2.0 (DB files are compatible — the database upgrades in place, no dump/restore needed) ORDS 26.1.0 → 26.1.2 New scrip...

YouTube video by United Codes

Plug-and-play dockerized local Oracle APEX environment with Oracle 26ai and ORDS - United-Codes/uc-local-apex-dev

APEX 26.1 was finally released yesterday. Learn how to quickly set it up locally and test the new features with uc-local-apex-dev.

Build APEX AI agents with UC AI thanks to the new chat plug-in

APEX 26.1 brings native LLM function calling to PL/SQL. Here's how to design tools that the model actually uses correctly: scope, validation, and security.

Migration guide: https://www.united-codes.com/products/uc-local-apex-dev/docs/migrations/26-2/ Changes DB 23.26.0.0 → 23.26.1.0 (DB files are compatible) ORDS 25.4 → 26.1 Enhanced scripts drop-us...

YouTube video by United Codes

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