Sorting an Oracle Nested Table

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

Queuing for Oracle APEX (Part 2)

In Part 1 of this article I described the steps required to first create a queue and then how to enqueue messages using server side PL/SQL called from an Apex application. In part 2 I will describe the steps required to dequeue the messages and how they may be displayed using Apex. The first step […]