Category Archive for "Tips and Tricks"

Interesting Apex articles to read

Just posting some links, as an online-reading list Throttled File Loading with Node.js & Oracle Database https://jsao.io/2015/03/throttled-file-loading-with-node-js-oracle-database/ Apex 5 APEX 5 EA Impressions: Custom jQuery / jQuery UI implementations http://www.apex-at-work.com/2015/03/apex-5-ea-impressions-custom-jquery.html APEX 5 EA Impressions: Page Designer (Part 1) http://www.apex-at-work.com/2015/03/apex-5-ea-impressions-pager-designer.html APEX

Read More
APEX: Save a user’s checkbox selection on local PC

You want a checkbox item on a page which is a preference, you want it to be remembered for the user across login sessions, but you don’t want the overhead of storing it in a database table. You might choose

Read More
APEX Dictionary – Comparing two Interactive Reports

Recently I again had the requirement to compare two Interactive Reports from different applications. Using the power of the APEX Dictionary this can be done quite easily.

Read More
Query the APEX Metadata – #1 – Identify Public Pages

As i introduced the my APEX QA Plugin, i was asked if i could help other people to get some special information out of the metadata of APEX. Especially in APEX, where every configuration is saved in the database, it’s

Read More
jQuery – loop through a Tabular Form

This question is one of the frequently asked questions – "How do I loop through a tabular form using a dynamic action?". This example shows how to loop through a tabular form and set the values for each row to

Read More
Handling a slow loading APEX Home Page – the easy way

Recently someone was asking me this question via e-mail: “On my home page I have defined a couple of PL/SQL processes that take a long time – like 30 seconds – to finish. These processes fill up some collections that

Read More
Process Message During Page Rendering

In this blog post I discussed how the processing message can be shown when we have a page process that may take a while to process.  Sometimes the delay may occur when the page is being rendered.  We may not

Read More
Recognize your APEX dev, qa and prod environments

Here is a very quick entry, mostly to document how I sometimes keep applications in dev and QA (or prod) apart.  Lately I’ve been working with development and QA applications that live in the same workspace and server. Dev would

Read More
Execute PL/SQL in background

PL/SQL Logik in APEX zu platzieren ist etwas völlig Normales und findet nahezu überall täglich statt. Gelegentlich kommt es aber vor, dass aus APEX heraus solche PL/SQL-Logik angestoßen werden soll, die länger laufen wird. Hinterlegt man diese ganz normal als

Read More
Referencing USER in APEX

It’s not uncommon to reference the current user as USER in your pl/sql code. A simple use case may be to determine the client or environment that you’re running in (ex: dev, test, prod). Referencing USER will have some slight

Read More