- Powered by
- WordPress
-
Simplified TDE configuration in Oracle Database 23ai Free
The newly published Database 23ai RPM provide a new configuration option named CONFIGURE_TDE. Setting it to true creates a new database with TDE enabled in united mode.
-
Cloning PDBs with TDE enabled just got a lot easier with ORDS
-
Creating a GraphQL endpoint … within the database
GraphQL is protocol agnostic. Most GraphQL is served via HTTP, but there is nothing wrong with a different format. Why not put a GraphQL endpoint into the database? This post shows you how to do that.
-
Fetch()-ing GraphQL data in MLE/JavaScript
This post demonstrates how to use the new GraphQL endpoint ORDS provides in MLE/JavaScript. The first part covers the basics, the second one details the use of the graphql.js module.
-
SQLcl: new lb generate-schema option to overwrite files
I have written a lot about SQLcl’s Liquibase integration because I’m a great fan of it. One of the things it allows me to do is to generate the changelog for an entire schema. I’m using that a fair bit as part of schema migrations. Liquibase follows the delta approach, where a change depends on…
-
SodaDocumentCursor is iterable in node-oracledb 6.4 👏
-
Ad-hoc MLE JavaScript in Oracle AI Database 26ai: Database Actions
A short post describing how to use Database Actions to run some ad-hoc JavaScript code
-
Ad-hoc MLE/ JavaScript execution in Oracle Database 23ai: DBMS_MLE
Occasionally it makes sense to run In-Database JavaScript code in an ad-hoc fashion. You typically do that to test something before wrapping the JavaScript code into a module. There are many ways to achieve this goal: using DBMS_MLE directly (this article) using APEX’s SQL Workshop using Database Actions This post demonstrates how to use DBMS_MLE…
-
Ad-hoc MLE JavaScript in Oracle Database 23c: APEX
-
Using server-side JavaScript in APEX processes
Before you can use the MLE module you have to create an MLE environment first. Still in the object browser, create a new MLE env and name it TIMEKEEPING_ENV. Assign timekeeping as the import name, pointing to the TIMEKEEPING_MODULE you just created. The final step is to assign the newly created environment to the APEX…
