2025-03-18
dbLinter logo
2025-03-18
Categories

dbLinter Rules Repository

Introduction Today I proudly announce that the Joint Venture between United Codes and Grisselbav released the initial version of the dbLinter Rules Repository website. This is the first publicly available component of the dbLinter tool suite. What is dbLinter? dbLinter is a suite for checking and improving the quality of database applications. […]
Do you like it?
0 Read more
2025-03-08
PL/SQL Unwrapper for VS Code
2025-03-08
Categories

Wrapping and Unwrapping PL/SQL

Introduction Today I released a PL/SQL Unwrapper for VS Code. You can find it in the VS Code Marketplace, along with instructions on how to use it. It’s super easy and works the same way as the extension I wrote 10 years ago for SQL Developer in Java. If you’re curious about […]
Do you like it?
2 Read more
2024-10-16
PL/SQL vs. JavaScrit in the Oracle Database 23ai
2024-10-16
Categories

PL/SQL vs. JavaScript in the Oracle Database 23ai #JoelKallmanDay

JavaScript is the first language supported by the Multilingual Engine (MLE) in Oracle Database 23ai. Having additional languages in the Oracle Database allows us to use existing libraries within the database. Also, it makes it easier for those without PL/SQL skills to get started with database development. Wasn’t that also the argument […]
Do you like it?
2 Read more
2024-09-30
Cartoon-style kiss emoji
2024-09-30
Categories

How Many Bytes Are in an Emoji?

What Is a Byte? A byte is made up of 8 bits. And in the old days, it represented a character. If you use a single-byte character set such as WE8MSWIN1252, WE8ISO8859P15 or similar, it still is. What Is a Character? We can find definitions for example on Wikipedia and in the […]
Do you like it?
4 Read more
2023-12-18
Crime Scene Do Not Cross
2023-12-18
Categories

Autonomous Transactions

Introduction Autonomous transactions became available in the Oracle Database 8i Release 1 (8.1.5). 25 years ago. Before then the feature was used only internally, for example, when requesting a new value from a sequence. I mean, if Oracle is using autonomous transactions internally and they’ve made them public, then the usage can […]
Do you like it?
0 Read more
2023-11-26
Installing MLE Modules in the Oracle Database 23c
2023-11-26
Categories

Installing MLE Modules in the Oracle Database

Introduction In my previous blog post, I’ve shown how you can deploy an npm module from a URL and a custom ESM module from a local file into a remote Oracle Database 23c using JavaScript and SQLcl. This works well. However, for two MLE modules, I had to write 22 lines of […]
Do you like it?
0 Read more
2023-11-12
Solution design of the demo application
2023-11-12
Categories

MLE TypeScript & JavaScript Modules

Introduction The Oracle Database 23c supports MLE JavaScript modules. MLE modules are standard ECMAScript 2022 modules. The easiest way to develop such modules is outside the database. This allows us to take advantage of the extensive JavaScript ecosystem and develop MLE modules in TypeScript instead of JavaScript. In this blog post, I […]
Do you like it?
1 Read more
2022-10-30
optimizer_secure_view_merging=true
2022-10-30
Categories

optimizer_secure_view_merging and plsql_declarations

The Original Problem A customer is currently upgrading some Oracle databases from 11.2 to 19c. One query was extremely slow on the new test system and my job was to find out why. The root cause was that the database parameter optimizer_secure_view_merging was set to a different value. In 19c true and […]
Do you like it?
3 Read more
2022-10-11
Quoted Identifiers
2022-10-11
Categories

Quoted Identifiers #JoelKallmanDay

Background and TL;DR Connor McDonald wrote a blog post named Cleaner DDL than DBMS_METADATA. Back then he asked me if it would be possible to let the formatter remove unnecessary double quotes from quoted identifiers. Yes, of course. Actually, the current version of the PL/SQL & SQL Formatter Settings does exactly that. […]
Do you like it?
0 Read more
2022-09-25
DOAG2022 - The Oracle User Conference
2022-09-25
Categories

DOAG2022 Highlights

Nobody knows what kind of restrictions we will experience later this year. That’s why the DOAG Conference + Exhibition 2022 took place in September instead of November. The organizers wanted an in-person event. While you can access some chosen content remotely an in-person event has a lot of advantages, like getting in […]
Do you like it?
0 Read more