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 […]
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 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 […]
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 […]
iancarpenter.dev 
You must be logged in to post a comment.