I previously discussed new features in 22.2 here.
With a deep dive on the MLE feature here.
Creating an Always Free Autonomous Database in the Oracle Cloud (OCI) is one of the easiest ways to have a go with 21c.
JS in the SQL Worksheet
const oracledb = require("mle-js-oracledb"); const sql = "SELECT * FROM strava fetch first 1 rows only"; // execute query const result = oracledb.defaultConnection().execute(sql); console.log(JSON.stringify(result.rows));
And then I can run it.
If you open up your browser dev tools, you can observe the POST to _/sql where we execute your code.
So we just save you some typing.
If you want total control, just stay in the default SQL mode of the worksheet, and run PL/SQL blocks as you normally would.
First time visit to the worksheet as ADMIN?
You might see a warning like this –
You’re not necessarily doing anything wrong. But, ADMIN is a very powerful account, in fact it’s the most powerful account available for your database.
So, you probably do not want to put your application data and programs in this schema.
One last thing…yes you can pretty print JSON 🙂