2023-02-04

IslandSQL Episode 1: Select Statement

Introduction An island grammar focuses only on a small part of a grammar. The island represents the small, interesting part and the sea the rest. In this blog post, I explain the components of an island grammar for SQL scripts named IslandSQL. In the first iteration, we focus on the select statement. Everything […]
2022-07-31

Testing With utPLSQL – Made Easy With SQL Developer

Nowadays, everything is about automation. Software testing is no exception. After an introduction, we will create and run utPLSQL tests with Oracle SQL Developer for a fictitious user story. Our tests will cover a PL/SQL package, a virtual column, two database triggers and a view. The full code samples can be found […]
2020-06-07

utPLSQL for SQL Developer 1.2 – What’s New?

Today I released an update of the utPLSQL extension for SQL Developer. In this blog post, I explain the changes in the latest version 1.2. These are the new features: Download the latest version from GitHub. Debug Test Now you can run one or more utPLSQL tests with the PL/SQL Debugger. To […]
2020-06-06

Bye bye Xtend, Welcome Java

Introduction The utPLSQL extension for SQL Developer was originally written in Xtend. In this blog post I explain why we decided to migrate the project to Java and how we’ve done that. Why Replace Xtend? Xtend is a statically typed, clean language with excellent string templating features and a fine integration into […]
2019-07-06

Running utPLSQL Tests in SQL Developer

Introduction In November 2017 Jacek Gebal asked me if I could help to integrate utPLSQL into SQL Developer. In January 2018 we released the first MVP. Tests were executed in a new SQL Developer worksheet showing the result in the script output pane. This was easy to implement and it simplified the […]
2018-05-06

Why and How Using the accessible_by_clause

The accessible_by_clause was introduced in Oracle Database 12 Release 1 and extended in Release 2. If you don‘t know this feature, I suggest having a look at the documentation or reading Steven Feuerstein’s blog post. In this blog post, I talk about how to use this feature properly. Consider you have a […]