#100CodeExamples
Split a String into Rows – Revisited
My previous solution to split a string into rows by a delimiter, using pure SQL had a couple of small flaws.
Here is the revisited version that also removes a bit of code duplication.
PL/SQL
Feuertips #13: My Preconditions for Refactoring
Steven Feuerstein will do some live refactoring in his “Feuertips” episode #13.
However, in order to confidently refactor, one could use some automated tests that ensure the functionality doesn’t change…
#100CodeExamples
Split a String into Rows by Delimiter (with Pure SQL)
Sometimes we have data that is not split into columns and rows, but SQL can only really thrive on structured data.
But thanks to recursive queries we can split any string into rows – with pure SQL.
#100CodeExamples
PL/SQL Subtype Constraints don’t work from SQL
It is a common practice to eliminate possible NULL values from your method’s parameters, and in the past I advocated to use subtypes to do this in PL/SQL.
However, it doesn’t work from SQL…
Programming Concepts
List Comprehension – What Is It And Does It Only Exist In Python?
Thanks to my trainees I learned a new term: “List Comprehension”. But what is it and does it only exist in Python?
Advent Of Code 2020
Advent Of Code – Day 11: “Seating System”
I just completed #AdventOfCode in #SQL – Day 11 – “Seating System”
Game of Life implementation with the help of the MODEL clause and also in PL/SQL, showing the limits of SQL
Advent Of Code 2020
Advent Of Code – Day 10: “Adapter Array”
I just completed #AdventOfCode in #SQL – Day 10 – “Adapter Array”
WHAT THE SITH DID I JUST DO IN PLAIN SQL?
Advent Of Code 2020
Advent Of Code – Day 9: “Encoding Error”
I just completed #AdventOfCode in #SQL – Day 9 – “Encoding Error”
Who said you HAD to use a set-based approach when writing SQL?
Part 2 shows that we *can* implement complex recursive algorithms if we want.
Advent Of Code 2020
Advent Of Code – Day 8: “Handheld Halting”
I just completed #AdventOfCode in #SQL – Day 8 – “Handheld Halting”
Did you ever debug an infinite loop of a simple command-based program with the help of SQL? Very, very fun!
Advent Of Code 2020
Advent Of Code – Day 7: “Handy Haversacks”
I just completed #AdventOfCode in #SQL – Day 7 – “Handy Haversacks”
It’s all about recursive subqueries today, one of the most important elements to make SQL turing complete.