Starting with SQL Developer Web version 22.2, you can now work with:
This is a Database 21c feature, and it’s part of the Multilingual Engine feature of the Oracle Database. And since we only get paid if we invent new acronyms, that would be ‘MLE.’
The code you are about to see below came from one of our MLE Developer Advocates – Alina Yurenko.
I do PL/SQL, why would I care?
Now let’s run some code!
I’m logged into a 21c Instance of Oracle, AND I have exec privs on the MLE package (Docs.)
When I have these two requirements satisfied, I see a SQL Worksheet a bit like this –
But my code above already has that PL/SQL code written, so I can just use the default action.
Select and Execute
Well, how does that work?
SQL Developer generated the DBMS_MLE bits for you. You can see that if we look at the SQL History for that call.
Ask and ye shall receive.
Ok, it’s exactly what it sounds like.
Let’s try it.
Reminder: I’m your friendly database tools expert.