26ai Free

Optimistic Locking Made Easy: JSON Relational Duality Views & ETags in React

In my previous post I demonstrated how ETags can help your web application implement concurrent data…
Optimistic Locking Made Easy: The Power of ETags in Action

JSON Relational Duality Views are one of the most remarkable features introduced with Oracle AI Database…
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…
Say hello to the all new server-side JavaScript LiveLab

In-Database JavaScript, powered by Multilingual Engine (MLE) debuted as a major feature in Oracle AI Database…
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…
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,…