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 […]
There is an excellent article on Writing PL/SQL in Oracle Application Express in the March/April 2014 edition of the Oracle Magazine. There is a lot of useful information about where your code should be located. My favourite part of the article is comparison between the parameterless function relying on the Apex V function and a […]
Oracle have published a white paper entitled: “With Oracle Database 12c there is all the more reason to use database PL/SQL” it’s author is Bryn Llewellyn who is the Product Manager for PL/SQL. In this paper Bryn lists the reasons he hears from customers on why they are not using PL/SQL in the database and […]
In this article I will describe a method which enables you to list the contents of a Linux directory from within Oracle using the 11gR2 Preprocessor feature of Oracle External Tables. The example that follows was built using the Oracle Developer Days Environment and used the following versions: Oracle Linux running via Oracle Virtual Box […]
iancarpenter.dev 
You must be logged in to post a comment.