Developer Sam
  • Blog
  • About
  • Public Speaking

Advent Of Code 2020

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

By Sam, 2 yearsDecember 15, 2020 ago
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?

By Sam, 2 years ago
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.

By Sam, 2 years ago
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!

By Sam, 2 years ago
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.

By Sam, 2 years ago
Advent Of Code 2020

Advent Of Code – Day 6: “Custom Customs”

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.

By Sam, 2 years ago
Advent Of Code 2020

Advent Of Code – Day 5: “Binary Boarding”

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!

By Sam, 2 years ago
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

By Sam, 2 years ago
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!

By Sam, 2 years ago
Advent Of Code 2020

Advent Of Code – Day 2: “Password Philosophy”

I just completed “Password Philosophy” – Day 2 – #AdventOfCode 2020 in pure #SQL

By Sam, 2 years ago

Posts navigation

1 2 Next
Tags
#100CodeExamples AdventOfCode2020 Agile APEXConnect Charset CheatSheet Clarity Clean Code Compassione Coding Conferences Continuous Integration Decision Making DesignRules DOAG Don't Repeat Yourself Dunning-Kruger-effect EDD Empathy Evolutionary Fun JavaScript Learning Life Migration MINUS Oracle OracleACE Personal Growth PL/SQL Public Talking Puzzle Readability Reflection Self-Awareness Self-Testing Software Design Software Quality Speaking SQL SQL Types TDD Team Testing Unit-Testing utPLSQL
Categories
  • #100CodeExamples
  • Advent Of Code 2020
  • BeckDesignRules
  • Book Club
  • Fun
  • Humans
  • Java
  • Oracle ACE
  • PL/SQL
  • Programming Concepts
  • Public Speaking
  • Reflections
  • SQL
  • Testing
  • Tooling
  • Uncategorized
  • utPLSQL
Archives
  • January 2023
  • December 2022
  • July 2022
  • May 2022
  • December 2021
  • July 2021
  • June 2021
  • March 2021
  • February 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • April 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • September 2018
  • August 2018
  • June 2018
  • May 2018
  • March 2018
  • January 2018
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • May 2016
  • Imprint / Impressum
  • Contact
Hestia | Developed by ThemeIsle