2021-08-29

Do Not Format Invalid Code in SQL Developer

Introduction What happens when you call the formatter in SQL Developer for invalid code? Until recently SQL Developer tried to format it anyway. This produced strange results in some cases. Starting with SQL Developer version 21.2.0 there is a hidden option to suppress formatting when the code is invalid. What Is Valid […]
2021-07-18

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 […]
2021-03-10

Work From Home – First Anniversary

The last time I was on-site at a customer was March 10, 2020. I usually spent about 20-40% of my time working from home. But working exclusively from home is something completely different. A new experience. After a year it’s time for a brief personal retrospection. The Good More at Home Pretty […]
2021-02-28

Connecting via JDBC to the Oracle Cloud

You can connect to an Oracle Autonomous Database in different ways. This is well documented here. It’s a bit different from what we know from on-premises environments. In this blog post, I show the steps to connect to an Autonomous Database from a third-party IDE like DataGrip. From a JDBC perspective, this is […]
2021-01-17

Accessing Snowflake from SQL Developer

My first day of work this year was a training day. As a participant in a “Snowflake Fundamentals” training course. I opted for the four-day, multi-week option so that I would have time to better absorb what I had just learned. Tomorrow is my third day and I plan to write more […]