Advent Of Code 2020
Advent Of Code – Day 4: “Passport Processing”
I just completed “Passport Processing” – Day 4 – #AdventOfCode 2020 in #SQL
It’s all about how you get from unstructured to structured data
Advent Of Code 2020
Advent Of Code – Day 3: “Toboggan Trajectory”
I’ve completed “Toboggan Trajectory” – Day 3 – #AdventOfCode 2020 in SQL.
Recursive Subqueries and PIVOT for the win!
Advent Of Code 2020
Advent Of Code – Day 2: “Password Philosophy”
I just completed “Password Philosophy” – Day 2 – #AdventOfCode 2020 in pure #SQL
Advent Of Code 2020
Advent Of Code in SQL (and PL/SQL if necessary)
I’ll try to solve the #AdventOfCode2020 with SQL (and PL/SQL if necessary).
First challenge is to find the two numbers of a list that sum up to 2020 and multiply them.
Uncategorized
First-Time presenting in a lot of locations – virtually
I know, that the fact nearly all tech events went online has a reason, and I genuinely would like it to be different. However, I enjoy to present in a lot of different locations this year that would be absolutely unreachable for me otherwise (most Oracle Usergroup conferences will not cover travel and hotel for speakers – but that’s a Read more…
Uncategorized
Creating a Matrix-like Virtual Background with JavaScript
I always wanted a Matrix-like Virtual Background and thought I could implement it myself with a bit of JavaScript.
Uncategorized
utPLSQL 3.1.10 CheatSheet
Today is my birthday and to celebrate it I want to give a new and update utPLSQL CheatSheet to the community
#100CodeExamples
Well-Testable Code: Dealing with the “Popular Sith”-Sequence
My last example of controlling a sequence to test some default-behavior was not “well-testable” PL/SQL code.
In this example I show how we can achieve a method that is much easier to test, doesn’t require touching internals – all without changing the public API of the method.
#100CodeExamples
utPLSQL and ORA-04061 – Global State and Package Invalidation
A combination of Package global state and Package invalidation can easily lead to ORA-04061 errors, especially in unit-testing situations.
This blog-post explains the problem and shows possible solutions (all with examples)
Uncategorized
“But that worked yesterday!” or, why you should test with utPLSQL
Automated self-tests are a fundamental part of application- and web-development
nowadays, even to the point where one can’t imagine modern software development
without them. Yet they are still surprisingly uncommon in the database.
This article shows how easy it is to start developing self-tests in Oracle with utPLSQL
version 3 and what benefits these tests will bring to your project
and your software.