The easiest way to get started with Oracle’s Application Express…
…is simply to go here and create an account. This will get you up and running with Application Express without even leaving your browser.
Using SQL with Associative Arrays of records in Oracle 12c
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 […]
A simple example of using the Oracle ROLLUP extension
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 […]
In Oracle SQL, why doesn’t ROWNUM = 2 work?
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 […]
Does using a sequence in a PL/SQL expression improve performance?
In versions of the Oracle Database prior to 11g Release 1, to populate a variable with the next value from a sequence you would have call the NEXTVAL function from within a SQL statement. From Oracle Database 11g Release 1 you can now use the NEXTVAL function in a PL/SQL expression. So other than less […]
iancarpenter.dev 
You must be logged in to post a comment.