Re-reading Code Complete 2 recently, I came across the concept of Structured Basis Testing which despite its foreboding name is in fact an easy to understand and straight forward method that you can use to calculate the minimum number of unit test required to exercise every path through a function or procedure. Structured Basis testing […]
A quick tip in case you run into the following problem as I did with a Raspberry Pi 3 running the Jessie version of Raspbian. Problem Unable to access the Internet using the Raspberry Pi’s built in WiFi. Symptoms You can successfully connect to the WiFi network You are unable to access any Internet sites. […]
The goal of this post is to build a prototype that demonstrates the auditing capabilities of Flashback Data Archive in Oracle 12c. Although the documentation mentions that Flashback Data Archive provides the ability to track and store transactional changes to a table I was struggling to see how this functionality actually worked and what audit […]
Since dbms_utility.format_error_backtrace has been available from Oracle 10g this isn’t another what it ishow to use it post. Instead I will be taking this opportunity to discuss a nuance of dbms_utility.format_error_backtrace that you may not be aware of. dbms_utility.format_error_backtrace reports the call stack back to the exception or the last raise statement which if you […]
In this article I will demonstrate a method where the INSERTALL statement can be used to insert rows into two tables that are related by a foreign key constraint. The following example was developed and tested using the Pre-Built Oracle Database App Development VM which at the time of this post used Oracle Database 12.1.0.2.0 & SQL […]
iancarpenter.dev 
You must be logged in to post a comment.