2020-06-21
blank

Names Matter

This is one of my favorite quotes: There are only two hard things in Computer Science: cache invalidation and naming things. — Phil Karlton IT is my daily live. And this quote is so true. Lately I’ve been thinking much more than usual about naming, and that names really matter. This led […]
2020-06-07
blank

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: Debug Test Cancel Test Run Test Run with Code Coverage Java instead of Xtend Download the latest version from GitHub. Debug Test […]
2020-06-06
blank

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 […]
2020-04-26
blank

Syntax Highlighting With SQL Developer

Introduction A customer asked me if it is possible to show unused identifiers in SQL Developer. Since there is no PL/SQL compile warning for that, you might be tempted to say no. But you can always use PL/SQL Cop for static code analysis. Guideline G-1030 deals with variables and constants and guideline […]
2020-04-13
blank

Formatting Code With SQL Developer

Introduction I started using SQL Developer in 2013. Back then version 4.0 was the latest and greatest. But the capabilities of the formatter were disappointing. In 2017 Oracle released version 4.2 with a new formatter and has been improving it ever since. Version 19.2 brought us dynamic JavaScript actions within the parse-tree […]