Developer Sam
  • Blog
  • About
  • Public Speaking

Blog

Book Club

ATDBC – Agile Testing Condensed, Part 1

After the fabulous ATD 2021, I wanted to stay in touch, and one idea was to start an Agile Testing Days Book Club (ATDBC).
The first book we’re reading is “Agile Testing Condensed” by Lisa Crispin and Janet Gregory. Here’s Part 1

By Sam, 5 monthsDecember 14, 2021 ago
SQL

SQLcl LOAD messing with Decimals, Dates and Locale – And How to Make it Work

SQLcl is a great tool, but it has its problems when it comes to environments other than English/US.
I show a couple of Problems and Strangenesses here and give examples how to work around them.

By Sam, 10 monthsJuly 30, 2021 ago
#100CodeExamples

Sort a Version-String with pure SQL

Ever tried to sort Version-Strings with pure SQL – for example when you want to find the highest Flyway version installed in your database?
Let me show you how you can!

By Sam, 10 monthsJuly 15, 2021 ago
#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.

By Sam, 11 monthsJune 22, 2021 ago
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…

By Sam, 11 monthsJune 15, 2021 ago
#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.

By Sam, 1 yearMarch 12, 2021 ago
Image by Andrew Martin from Pixabay
#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…

By Sam, 1 yearFebruary 10, 2021 ago
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?

By Sam, 1 yearFebruary 10, 2021 ago
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, 1 yearDecember 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, 1 year ago

Posts navigation

1 2 … 7 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
  • Java
  • Oracle ACE
  • PL/SQL
  • Programming Concepts
  • Reflections
  • SQL
  • Testing
  • Tooling
  • Uncategorized
  • utPLSQL
Archives
  • 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