Martin Bach

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…
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…
Passing JSON PL/SQL types to MLE JavaScript

Recently the MLE team was asked if it was possible to pass JSON PL/SQL types to…
What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 1

Oracle AI Database has been released! It ships with a whole raft of cool new features,…
Using Oracle Database Free in your devcontainer and GitHub Codespaces

Dev containers are pretty nifty when it comes to keeping your development environment isolated from the…