Reflections
WordPress, Ads and Yak Shaving
I’m a strong cricitc of the attention-driven industry and for my blog ran on the free plan WordPress-platform I considered moving the whole blog to a static site – not noticing I was about to shave a Yak…
#100CodeExamples
#100CodeExamples – Test updatable views with utPLSQL Cursors
If it comes to testing updatable views, the use of nested tables from ROWTYPE records in combination with utPLSQL’s cursor comparison is invaluable.
#100CodeExamples
#100CodeExamples – Constants in PL/SQL and SQL
Constants help us lazy devs in many ways, reduce the likelyness of unnoticed typos and prevent a given value from changing.
While PL/SQL supports them, it’s a bit tricky to get them into SQL.