JavaScript Archives - Philipp Salvisberg's Blog

2024-10-16

PL/SQL vs. JavaScrit in the Oracle Database 23ai

2024-10-16

Categories

Oracle

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 […]

2023-11-26

Installing MLE Modules in the Oracle Database 23c

2023-11-26

Categories

Oracle

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 […]

2023-11-12

2023-11-12

Categories

Oracle

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 […]

2022-10-11

2022-10-11

Categories

Oracle

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. […]

2021-12-29

2021-12-29

Categories

Oracle

GraalVM Native Image – First Impressions

Introduction A native image is an operating system-specific executable file. You can build such an image for basically every application running on a Java virtual machine. This approach promises faster start-up times and lower resource consumption. This makes it appealing for serverless computing, auto-scaling platforms and command-line tools. I gained some impressions […]

2021-07-18

Categories

Oracle

Lightweight Formatter for PL/SQL & SQL

TL;DR Bye bye, heavyweight formatter. Long live the lightweight formatter. Are you using Oracle’s SQL Developer or SQLcl? Then install these settings and press Ctrl-F7 to produce code that conforms to the Trivadis PL/SQL & SQL Coding Style. A compromise between conformity and individuality. Heavyweight Formatter A typical PL/SQL & SQL formatter […]

2020-11-12

Categories

Oracle

Formatter Callback Functions

Introduction In this blog post, I explained how the formatter in SQL Developer works and outlined how you can change the formatter result using Arbori and JavaScript. In this post, I explain what exactly the provided formatter callback functions do. For that, I use simple examples. I produced all results with a […]

2020-10-10

Categories

Oracle

Navigation in Large PL/SQL Code

Are you editing large PL/SQL code in SQL Developer? Have you noticed that sometimes you cannot navigate to a declaration anymore? No Ctrl-Click under Windows. No Command-Click under macOS. In this blog post, I explain the reason and how to fix that in SQL Developer 20.2. What Is Large? Usually, we define […]

2020-09-28

Categories

Oracle

Disable Formatter for Code Sections in SQL Developer

In this blog post, I show how you can disable the formatter for some parts of your code. IntelliJ IDEA and the Eclipse IDE use tags in comments to identify sections of code that must not be formatted. By default, these tags are `@formatter:off` and `@formatter:on`. Example When I format this code […]

2020-09-07

Categories

Oracle

Highlight Hints in SQL Developer

Introduction In this blog post, I explain how you can configure your SQL Developer to highlight hints and distinguish them from ordinary comments. The SQL Language Reference for Oracle Database 19c defines hints as follows: Hints are comments in a SQL statement that pass instructions to the Oracle Database optimizer. The optimizer […]