This article demonstrates a method used to sort an Oracle nested table collection from within PL/SQL . The example that follows was built using the Oracle Developer Days Environment and used the following versions: Oracle Linux running via Oracle Virtual Box Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 Oracle SQL Developer 3.2.20.10 The user developing […]
In this article I will explain what DBMS_PARALLEL_EXECUTE is and give an example of it’s use. DBMS_PARALLEL_EXECUTE is an Oracle Supplied package which was introduced with Oracle Database 11g Release 2. It allows you to execute a SQL or PLSQL statement in parallel. At a high level DBMS_PARALLEL_EXECUTE works by performing the following steps: Group […]
In this first of a two part article I will demonstrate the use of Oracle Streams Advanced Queuing (AQ) with Application Express. The first part will cover the creating a new queue and adding a message to the queue. Whilst the second part will concentrate on how to dequeue messages. In building the demonstration I […]
In this article I will explain the method I use when I need to process an indeterminate number of rows using PL/SQL. I became aware of this method after reading Bryn Llewellyn’s white paper Doing SQL From PL/SQL: Best and Worst Practises (My example is based on the code shown on page 31 of the white paper) […]
“It was working yesterday…” Working in any form of shared development environment you will sooner or later hit a problem when something that used to work has either stopped working or is doing something it wasn’t doing before. So how do you find out what have changed? With regards PL/SQL objects such as Packages, Triggers […]
iancarpenter.dev 
You must be logged in to post a comment.