Linux

What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 3

Oracle AI Database has been released! It ships with a whole raft of cool new features,…
Retrieving the result of a PL/SQL computation in MLE/JavaScript

Recently, while working on a joint project with the APEX team, the need arose to rewrite…
JavaScript showcase: a fun playground environment for MLE/JavaScript in Oracle AI Database 26ai

I’m a huge fan of Oracle’s SQL Developer Extension for VSCode. I use it on a…
What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 2

Oracle AI Database has been released! It ships with a whole raft of cool new features,…
Does the MLE SQL Driver respect Virtual Private Database policies?

An interesting question came in today and it’s a great opportunity to elaborate a little on…
Git clone, but a specific branch, please

This is a super quick post mainly to remind myself that it is possible to (git)…
Multiple “for” clauses in dbms_stats’s method_opt

Recently, I encountered some frustration in recalling the correct syntax for the method_opt parameter in DBMS_STATS.…
More good reasons to use bind variables in cursors in Oracle

Bind variables are a best practice in Oracle database development. They offer significant benefits in performance,…
Creating column-level annotations on views

While updating my slides covering “what’s new in Oracle AI Database 26ai” I noticed that examples…
Using the MLE PL/SQL Foreign Function Interface in APEX

While preparing a talk for the upcoming annual German Oracle User Group conference, DOAG 2025, I…