#100CodeExamples
#100CodeExamples – SYSDATE vs. CURRENT_DATE
#100CodeExamples – SYSDATE vs. CURRENT_DATE
I had a very strange problem yesterday where #utPLSQL cli showed different test outcomes than running the tests from my IDE. Here’s the reason.
#100CodeExamples
#100CodeExamples – utPLSQL’s Suite Hierarchy in action
#100CodeExamples – utPLSQL’s Suite Hierarchy in action.
A great tool to structure tests, avoid duplication, give context and improve performance.
#100CodeExamples
#100CodeExamples – Dynamic values in a String: UTL_LMS
#100CodeExamples – How to put dynamic values in a String with #PLSQL.
One possibility: the sys-package UTL_LMS
#100CodeExamples
#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with Cursor Comparison
#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with the Cursor Comparison capabilities of utPLSQL.
#100CodeExamples
#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup
#100CodeExamples – A challenge to learn and teach.
My first example today: How to do a Primary/Replica lookup (in SQL) which I can query with the ID of any entry.