#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…