Following on from my earlier post, using VirtualBox with the pre-built Database App Development Virtual Machine is in my opinion, the second easiest method to getting up and running with Application Express. It is also my preferred method of prototyping, trying new features and providing answers to Stack Overflow Apex questions. I particularly like the […]
…is simply to go here and create an account. This will get you up and running with Application Express without even leaving your browser.
The ability of using SQL to operate on Associative Arrays or PL/SQL tables as they were known when I started working as a Database Developer is one of my favourite new features of 12c. I wasn’t aware of it until I read the post by Connor Mcdonald. It’s announcement within the new features guide is […]
Recently I needed to find out how many rows in a table had a certain status and display a grand total of the number of objects. In this post, rather than create a demo table with the various status I am going to base my example on the user_objects data dictionary view. Using the following […]
The inspiration for this post came after recently overhearing a developer asking why his query was not returning a row. It had been working fine, the only change was instead of ROWNUM = 1, he had changed it to ROWNUM = 2. The query was could have been doing something similar to the following: which […]
iancarpenter.dev 
You must be logged in to post a comment.