Introduction As an exceptional Oracle Developer you already know the value of instrumenting your code. You have read enough of Tom Kyte, Cary Millsap & Steve McConnell to understand that with the correct instrumentation diagnosing problems especially time critical problems (are there any others?) becomes much easier. So the question is not why you should instrument your […]
…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.