#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!
#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.
#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…
#100CodeExamples
Well-Testable Code: Dealing with the “Popular Sith”-Sequence
My last example of controlling a sequence to test some default-behavior was not “well-testable” PL/SQL code.
In this example I show how we can achieve a method that is much easier to test, doesn’t require touching internals – all without changing the public API of the method.
#100CodeExamples
utPLSQL and ORA-04061 – Global State and Package Invalidation
A combination of Package global state and Package invalidation can easily lead to ORA-04061 errors, especially in unit-testing situations.
This blog-post explains the problem and shows possible solutions (all with examples)
#100CodeExamples
Let Tests Tell a Story With utPLSQL Nested Contexts
Unit-Tests are automated checks of certain behavior. But what if we could also use them to describe what the functionality they’re checking is supposed to do?
#100CodeExamples
OGB Appreciation Day: Explore a utPLSQL test scenario with “force-manual-rollback”
How to explore some functionality you don’t know but want to change or improve?
Write a unit test with utPLSQL and use the force-manual-rollback param!
#ThanksOGB
#100CodeExamples
Concatenate a List of Strings in PL/SQL
How to concatenate a list of Strings in PL/SQL?
This blog-post shows 4 different approaches.
#100CodeExamples
PL/SQL Object Types: putting the Structure into the Force Powers Table
Object Types are a very useful thing when used in PL/SQL, but Oracle even allows us to have them inside a table.
Let’s see how we can put the numeric_strucutre-logic inside the Force Powers table and use indizes on the new column.