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.
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…
Thanks to my trainees I learned a new term: “List Comprehension”. But what is it and does it only exist in Python?
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
I just completed #AdventOfCode in #SQL – Day 10 – “Adapter Array”
WHAT THE SITH DID I JUST DO IN PLAIN SQL?
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.
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!
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.
I just completed #AdventOfCode in #SQL – Day 6 – “Custom Customs”
Window functions are so powerful – and sometimes a good bit of baseline data can make your SQL pretty efficient.
I just completed #AdventOfCode in #SQL – Day 5 – “Binary Boarding”
Binary sequences are fun, too bad Oracle doesn’t provide a convenient function to convert them.
Also: LAG and LEAD are your friends!