view counter


Oracle Application Express (APEX) resources, news, and support articles.

Some changes to be aware of, as Oracle Application Express 5 nears...

As the release of Oracle Application Express 5 gets closer, I thought it's worth pointing out some changes that customers should be aware of, and how an upgrade to Oracle Application Express 5 could impact their existing applications.

Custom CSV Export in APEX

Sometimes the standard export doesn't fit your requirements. For example you do not want the double apostrophe ".
In those cases take a look at these examples:

Tabular Form - Regular Expression Validation

A simple example how to check a tabular form column to be numeric with a max length of 2.

Use a regular expression validation:

APEX 5.0 Fixed Headings for Interactive Reports

When you click on the Attributes of your Interactive Report there's a neath little new features included called "Heading - Fixed to" with as options: None, Region and Page

APEX 5.0 EA3 - Universal Theme Styles - Gray!

In APEX 5.0 theme 42 is included - this is the Universal Theme. The theme comes with two styles: Blue and Gray.

APEX 5.0 - Run Applications in New Tabs

If you are using Firefox you will probably have an issue with running pages from APEX Builder 5.0 in new Tabs. Now, the links are working differently and normally clicking at button "Save and Run Page" will open a new window. In order to get it opened in a new tab, you will need a plugin Tab Mix Plus. Once you have it, you will need to change the settings there as shown in the screenshots below.

Test Drive Oracle APEX 5.0 Early Adopter 3!

It’s here! Oracle Application Express 5.0 Early Adopter 3 is available at and we are really looking forward to get your feedback (via the Feedback link in the Builder)! A list of all new features of EA3 and a … Continue reading

APEX 5.0 EA3 released with Universal Theme

Today Oracle released the latest Early Adopter release of APEX 5.0.

Preparing architecture for APEX 5.0 upgrade

I doubted to set the title of this post to "Running APEX 4.2 and 5.0 in the same Oracle instance", but decided not to do that, but that is basically what I will do. Before going into details, I'll share my architecture.

DATE - First and Last day of a month

Simple task and simple solution:

-- First day: 
select TRUNC(sysdate,'MON') as first_day from dual
-- Alternative:
select TO_DATE('01.'||TO_CHAR(SYSDATE,'MM.YYYY'),'DD.MM.YYYY') as first_day from dual
view counter