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 […]
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 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) […]
Introduction Introduced in Oracle 11g Release 2, the File Watcher enables jobs to be triggered when a file arrives in an Operating System Folder. In this article I am going to set up a new file watcher on my Windows PC. The example inserts the contents of the newly arrived file into a database table. […]
iancarpenter.dev 
You must be logged in to post a comment.