This is a far more opinionated post than usual. It is not meant to inflammatory, my goal for this post is to have something tangible that I can point to the next time an Oracle Developer thinks they want or need to “do” incremental commits. In this post an incremental […]
Estimated reading time: 5 minutes
In an earlier post I explained how you can use C# to access a Twitter stream. In this post I will show you how to save the tweets from a Twitter stream to RavenDB. The goal of this post is not to perform a deep dive into NOSQL databases or the […]
Estimated reading time: 8 minutes
I can’t remember using the PL/SQL construct where current of in code I have written so along with my usual article style of how use to use this feature, this is also an experiment to find out if there are any other reasons to use where current of. The code […]
Estimated reading time: 4 minutes
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 […]
Estimated reading time: 9 minutes
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 […]
Estimated reading time: 3 minutes