Oracle VM Consulting
view counter


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

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

Cookie Applikation

Ich habe in den letzten Tagen an einer Mini-Anwendung gearbeitet: "Cookie Applikation".

Die Verwendung von Cookies in APEX ist nicht kompliziert, ist aber ohne die passenden Beispiele etwas mühsam umzusetzen. Deswegen habe ich an einer Beispielanwendung gebaut, die genau die Funktionsweise der Cookie-Nutzung erläutert und LIVE darstellt.

Zusätzlich dazu habe ich den Super Cookie (Canvas Fingerprinting) beispielhaft implementiert.

view counter