Posts - Page 2 of 11 - Philipp Salvisberg's Blog

2024-06-15

IslandSQL Episode 8: What's New in Oracle Database 23.4?

2024-06-15

Categories

Oracle

IslandSQL Episode 8: What’s New in Oracle Database 23.4?

Introduction In the last episode, we looked at some features in PostgreSQL which I miss in the Oracle Database. The IslandSQL grammar now covers PL/SQL and the related DDL statements. The implementation was more complex than expected, mainly because of the incompatibilities between PostgreSQL and the Oracle Database. I will probably deal […]

2024-03-23

IslandSQL Episode 7: DML Statements in PostgreSQL 16 and What I Miss in Oracle Database 23c

2024-03-23

Categories

Oracle

IslandSQL Episode 7: DML Statements in PostgreSQL 16 and What I Miss in Oracle Database 23c

Introduction In the last episode, we covered DML statements in SQL*Plus/SQLcl scripts for the Oracle Database 23c. The IslandSQL grammar can now also handle PostgreSQL 16 DML statements in psql scripts. In this blog post, we will look at some features in PostgreSQL 16 which I miss in the Oracle Database 23c. […]

2024-01-30

IslandSQL Episode 6 - DML Statements in Oracle Database 23c

2024-01-30

Categories

Oracle

IslandSQL Episode 6: DML Statements in Oracle Database 23c

Introduction The IslandSQL grammar now covers all DML statements. This means call, delete, explain plan, insert, lock table, merge, select and update. In this episode, we will focus on new features in the Oracle Database 23c that can be used in insert, update, delete and merge statements. For the select statement see […]

2024-01-12

IslandSQL Episode 5 - Select in Oracle Database 23c

2024-01-12

Categories

Oracle

IslandSQL Episode 5: Select in Oracle Database 23c

Introduction In the last episode, we extended the expressions in the IslandSQL grammar to complete the lock table statement. The grammar now fully covers expressions, conditions and the select statement. In this episode, we will focus on optimizer hints and new features in the Oracle Database 23c that can be used in the […]

2023-12-18

2023-12-18

Categories

Oracle

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

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

2023-10-11

2023-10-11

Categories

Oracle

Sharing SQL Developer Connections #JoelKallmanDay

1. The Problem I created a Docker image and a container for the Oracle Database 19c (19.19) for Linux ARM. The container contains ORDS, APEX and various sample schemas. Finally, an Oracle database that runs pretty fast on my Apple Silicon machine. Then I built a cold database clone by creating a […]

2023-04-16

2023-04-16

Categories

Apple
Oracle

Oracle Database 23c on a Mac with an M-Series Chip

ARM Docker Images Now Available With the release of version 23.5 of Oracle Database 23ai, ARM builds are now available for Docker images. On the official Oracle Container Registry: And on Docker Hub provided by Gerald Venzl: This makes it very easy to use the Oracle Database on a Mac with an […]

2023-03-05

Categories

Oracle

IslandSQL Episode 4: Expressions

Introduction In the last episode, we extended the IslandSQL grammar covering the complete lock table statement. However, the support for expressions was very limited. It was not possible to use a date literal or to_date function to determine a partition to be locked. Time to fix that. In this episode, we will have […]