Martins Blog

Powered by: WordPress

Using QuickSQL to generate table DDL and sample data in Oracle Database 23ai without APEX
Using faker-js/Faker to generate test data respecting referential integrity in Oracle Database 23c
Using faker-js/SimpleFaker to produce test data in Oracle Database 23ai

After returning from an inspiring tech conference last week I had an agenda full of items to research. One of the talks I attended mentioned how simple it was for some popular open-source databases to generate sample data. Performing the same task with the Oracle Database was perceived to be quite tricky. This is only…
Configure PDB Lifecycle Management for ORDS 23.3
Working with JSON in Multilingual Engine/JavaScript in Oracle Database 23ai Free
MLE type mapping: passing JSON to JavaScript functions in Oracle Database 26ai

Everyone knows that JSON is very popular, and that includes its use in databases. Turns out that JavaScript is a popular way for working with JSON. Both can be used in Oracle AI Database 26ai Free. The question quickly arises: how do I pass a JSON variable from SQL or PL/SQL to a JavaScript function?…
Dealing securely with state changes in Multilingual Engine for Oracle Database 23c
Performance Monitoring for In-Database JavaScript in Oracle Database 23c #JoelKallmanDay
Using the Operating System’s certificate store instead of an Oracle wallet in Oracle Database 23ai

Both network and file I/O are a security-sensitive affair. Therefore you cannot simply write to a file, or open a network connection in Oracle Database without doing some setup work up front. Developers wishing to perform network I/O via UTL_HTTP for example must define fine-grained access control settings. Or rather, ask the administrator to perform…
Python one-liners: converting markdown to HTML

This has come in handy a number of times. Assuming you have an input file in markdown format and need to convert it to HTML. This is a low-tech solution to the problem, most importantly it is available for MacOS on M1 chips without any further software installation. And yes, it’s not the only solution…