view counter


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

Google Chrome+ OS X + VMWare Fusion 8.0.1 = No Bueno

As those who read my blog know, I recently started a new job with Oracle. A very large part of what i do means being connected internally through the Oracle VPN. Having been a consultant for many MANY years, I’ve come to the realization that putting a fence around VPN is a good idea wherever possible.

Opening of APEX R&D New Zealand

We're really excited to announce that next to our Belgium office, we have opened an office in New Zealand too. This will allow us to cover multiple timezones and better serve the Australian and New Zealand market.

Next Oracle APEX NOVA Meetup Date Set

The next Oracle APEX NOVA MeetUp is going to be held on November 12th, 2015 at 7PM.  We decided to mix things up a bit and are going to have it at Vapianos in the Reston Town Center.  We're also going to try a more informal agenda.  In other words, there will be no agenda.

So if you're around Reston on November 12th from 7-9PM (or so), feel free to stop by.  Here's the link:

Submit your abstract for KScope 16 - only 3 days left

Only 3 days left to submit your abstract for KScope 16... so don't wait longer, submit now! :)

Oracle Database Developer Choice Awards (2nd)

I was just looking at the voting results for ORDS and APEX. In the ORDS category Dietmar Aust is leading and in the category APEX it is Morten Braten. So far so good. These men deserve the award for sure - they did a lot for the community and the most of us are using (or have used) their solutions.

Analytische Funktionen (Teil 3): Gruppen mit zufälliger Auswahl der Datenbasis

Das folgende Beispiel bezieht sich auf die Datenbasis meines ersten Post zu "Analytischen Funktionen".
Es geht darum, dass für das Jahr 2014 drei Gruppen (mit einem Hash-Wert je Gruppe) gebildet werden müssen.
Gruppe 1:

DOAG 2015 noch wenige Wochen...

Noch wenige Wochen bis zur DOAG 2015.

Analytische Funktionen (Teil 2): LISTAGG mit eindeutiger Liste

Die LISTAGG Funktion dient der Generierung von zusammenkonkatenierten Strings auf Basis einer Spalte. Wenn in der Spalte ein Wert mehrfach vorkommt, dann wird die Liste ebenfalls mit doppelten Werten generiert.

DOAG Conference Presentation Summary Finished

Hi guys,

today was the deadline for uploading the four-page abstract / summary of my presentation at the German Oracle conference in Nürnberg:

Column Group Headings in an Interactive Report (APEX 5.0)

In 2008 I blogged about how to add Group Headings into an Interactive Report in Oracle Application Express (APEX 3.x!).

Here's an example what I mean with Group Headings, you want to logically group certain columns (e.g. Empno, Ename) and have a group name above them (e.g. Group 1):

view counter