About user

This author has not yet filled in any details.
So far user has created 28 blog entries.

Planning Page Numbers

There are numerous advantages for planning page numbers in Oracle Application Express. The more obvious is that you can group pages and order then based on function. Finding a page from a list of pages becomes easier with a plan.

By |2018-10-09T11:42:54+00:00May 4th, 2016|Planning Page Numbers|Comments Off on Planning Page Numbers

Oracle APEX 5 Sentry Function

The name is a pretty good clue: Sentry. A sentry stands a post and alerts others when issues arise. After a few hours of exploration, I see that the functions duties and its name are well matched. Let’s explore a bit together, eh?

By |2018-10-09T11:00:54+00:00January 31st, 2016|Oracle APEX, Oracle APEX 5|Comments Off on Oracle APEX 5 Sentry Function

Synchronize Sequence with Primary Key

Whilst migrating to Oracle 12c, it is clear that we will still have primary keys populated by sequences for years to come. When I pull production data over to our development server, I dread the steps required to synchronize the old sequences to the updated tables. Using the expdp / impdp, moving the tables has become routine and risk free.

By |2018-10-10T08:57:54+00:00January 31st, 2016|Oracle PL/SQL|Comments Off on Synchronize Sequence with Primary Key


Adding help to an application advances the professional look and polish of an application. Furthermore, adding help text to pages and page items forces the development team to stand back from their own work and view the effort from the user’s perspective. Oracle APEX provides several tools facilitate the process. It is our job to put them into place and get them working.

By |2018-10-10T09:00:20+00:00January 2nd, 2016|Oracle APEX|Comments Off on Help


We wanted a method of selecting number of items from a list using Oracle APEX. If picking 2 items from 10, a shuttle box may be optimal. If picking 2 of thousands, then a popup LOV (list of value) may be a better choice. What if your needs are in between?

By |2018-10-09T10:56:53+00:00January 2nd, 2016|Oracle APEX|Comments Off on APEX_ITEM.Check_box2