Oracle

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…
Quick tip concerning dbms_cloud’s create_credential() call

DBMS_CLOUD is one of the crucial packages in Oracle AI Autonomous Database (ADB from now on).…
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…
Why does my query run in parallel on Autonomous Database-Serverless even though I do everything to prevent it from doing so?

While preparing for another blog post I desperately wanted to write I noticed something unexpected. The…
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,…
Troubleshooting missing privileges in dbms_xplan.display_cursor

This is a quick note-to-self to make sure a database account has all the necessary privileges…