…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 […]
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 […]
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 […]
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 […]