Apex Bootstrap theme for download

The most popular UI framework on the internet now available for APEX!A group of Apex developers have joined hands and developed a free Twitter Bootstrap 3 Apex theme and made it available for everyone who wants to use it.

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
Adding CSS buttons to your report

I’ve liked this concept ever since I saw the packaged applications use this technique:

Read More
Automatically Add License Protection and Obfuscation to PL/SQL

Yesterday we released the new version 2.0 of our product PFCLObfuscate. This is a tool that allows you to automatically protect the intellectual property in your PL/SQL code (your design secrets) using obfuscation and now in version 2.0 we have

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