Martins Blog

Powered by: WordPress

Using sqlcl/Liquibase for administrative tasks
Advanced ORDS REST handlers written in JavaScript

There you go! In addition to using all the modules built into MLE you can also refer to your own. The new feature is documented in the ORDS Developer’s Guide, which contains a handy reference. Happy coding!
Installing Xfce on Oracle Linux 9

This post describes how to install
Matching the start-with value of an identity column with table data
Creating a GraphQL endpoint … within the database [redux]

$ sql emily@localhost/freepdb1SQLcl: Release 24.1 Production on Thu Jun 06 10:33:37 2024Copyright (c) 1982, 2024, Oracle. All rights reserved.Password? (**********?) Connected to:Oracle Database 23ai Free Release 23.0.0.0.0 – Develop, Learn, and Run for FreeVersion 23.4.0.24.05SQL> select 2 json_serialize( 3 graphql_query( 4 ‘query locById($id: Int) { getLocationById(id: $id) { city country_id } }’, 5 JSON(‘{id: 1000}’)…
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…