Me and the ODTUG Board

This afternoon my Twitter timeline exploded with retweets, likes and congratulations. It all started with this tweet:

So it's official now. As Sarah Zumbrum had to step down due to her (dream) move to Oracle, a position on the ODTUG board opened up. And I was asked whether I was still interested. And of course I was! So after an internal voting procedure, I received the good news last weekend - and had to keep (more...)

Slides and demo script from my ORDS talk at 2016 in Rotterdam

Hi everybody,

I just came back from the conference in Rotterdam ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure.

As promised, you can download the slides and the demo script (as is) from my site.

Instructions are included.

See you at APEX Connect in Berlin or KScope in Chicago, #letswreckthistogether .

Cheers and enyoy!

Add browser recognition on page inline CSS

Today I will show a code example how you can add browser recognition inside the "Inline CSS" mask of your APEX page.

Mehr »

APEX 5 – Opening and Closing Modal Window – Part Two

In this blog post from 2015 I explained how to open a modal window from an item and pass the values back, display a sucess message, etc. This page also contains an item plugin to make it easier to do the whole stuff and avoid hardcoding. I have never published this plugin. Hopefully this functionality is going to be a standard part of 5.1. Now, I was asked to make this working with a (more...)

CREATE an APEX_COLLECTION and SELECT the data via SQL Developer

Maybe this an old hat but a lot of people don't know how to use and analyze APEX_COLLECTION properly.  For myself it is a good reminder and saves me about 2 minutes instead of googling around.

In this example I will show you how to
- select the data in APEX reports
- analyze APEX_COLLECTION in SQL Developer

I will only show some basic steps. For a more detailed explanation (more...)

Change Item Position using jQuery

See this example on how to change the item position. In APEX you can position the buttons after the action bar in an interactive report. However, you can't put the items there. Using jQuery this is easy to achieve.

React on Tab Change

See this example on how to react on tab change in APEX 5. The problem is to determine the right selector to trigger the corresponding dynamic action. Thanks Christian Rokitta for your help.

Fragen rund um die APEX Dashboard Competition

In den letzten Tagen wurden mir mehrere Fragen rund um die APEX Dashboard Competition gestellt. Die Fragen und Antworten möchte ich gerne teilen:

In wieweit darf man das Universal Theme verändern? Darf die Anordnung der Regions geändert werden? Darf das Menü links entfernt werden?
Sie können mit dem Universal Theme machen was Sie wollen.
Einzige Einschränkung: Das Theme sollte nicht unter einer anderen ID abgespeichert werden. Dann wäre es ein Custom Theme und (more...)

Unexpected behaviour using SSO Authentication for APEX

A customer of mine switched to a Singe Sign On Authentication Scheme for their APEX application - using Oracle Access Manager, but that's irrelevant to this case.
In the application there's a function to create an - temporarily - "real" APEX user. That APEX user is used in another JavaScript application that uses ORDS and the built-in APEX authentication - thus requiring the existence of APEX users. That function ran flawlessly when the application was (more...)

APEX in the Cloud Day in Vienna

Are you in Vienna/Austria on February 25th 2016 and interested in APEX?

Then you have to come and join us at the “APEX in the Cloud Day” – reserve your seat right away!

APEX 5 – File Upload Bug

Today I had to suffer on a real APEX 5 bug.

When you upload a file the NLS settings in your current APEX session will be set to AMERICAN.
I check for issues like that and found a forum post where someone else was experiencing the same problems as I did:
File browse changes some NLS settings - possible bug

My purpose was to upload a CSV file and transforming it to table data. Now (more...)

Navigating through your APEX Calendar – the easy way

The renewed Calendar Region in APEX is awesome. With just one SQL statement you can provide your users with a calendar view of their data that looks very familiar to what they already know, use and love. Apart from one thing: Navigating to a specific date is cumbersome.
The shortest route is:

  • Navigate to the right month (can be any number of clicks) 
  • Switch to "Week view" 
  • Navigate to the right week (between 0 and (more...)

SQL: Texte mit Umlauten und Sonderzeichen normieren

Im heutigen Beispiel möchte ich einmal kurz aufzeigen, wie Sie einen Text nach Ihren Bedürfnissen hin normieren können. Ich habe dazu die bekanntesten Länder der Erde in einer WITH Clause zusammengefasst und bilde mir anhand des Namens einen später verwendbaren normierten String.

Der Zielstring muss GROSSGESCHRIEBEN sein und darf keine Umlaute (ÖÜÄöüäß) und Sonderzeichen (, '.()-) beinhalten.
Mehr »

Folien zum Webinar REST mit ORDS

Oracle hat zusammen mit der DOAG das Webinar "Modern Application Development" organisiert, darin habe ich auch ein Webinar (auf deutsch) zum Thema "Oracle als REST-Service mit ORDS – So geht‘s" beigesteuert.

Die Folien dazu findet Ihr hier.

Viele Grüße,

APEX shuttle item with one direction

In one application I had the requirement to set up a shuttle item to be half readonly. All you should do was to add new values from the left to the right side. You should not be allowed to remove values from the right side.

The result should look like that:
Mehr »

Show all views including a specific string

Seems to be a simple problem and easy to fix. Actually it is not because if you try one of these examples then you will fail:
Mehr »

Oracle Database 12c Features Now Available on

As a lot of people know, is the customer evaluation instance of Oracle Application Express (APEX).  It's a place where anyone on the planet can sign up for a workspace and "kick the tires" of APEX.  After a brief signup process, in a matter of minutes you have access to a slice of an Oracle Database, Oracle REST Data Services, and Oracle Application Express, all easily accessed through your Web (more...)

Switching Interactive Report to Icon or Detail View in APEX 5 using Javascript

At yesterdays APEX Meetup in Vienna someone asked if there is a way to switch an Interactive Report programmatically (using Javascript) to Icon / List / Report – View in APEX 5, since gReport doesn’t exist anymore (which could do the job before APEX 5).

Application_BuilderAbove you see an example of an Interactive Report everyone should know: this is the Application Builder listing all pages of an application.

The task at hand is to call (more...)

Stinkin’ Badges

Ever since APEX 5, the poor Navigation Bar has taken a back seat to the Navigation Menu. And for good reason, as the Navigation Menu offers a much more intuitive and flexible way to provide site-wide navigation that looks great, is responsive and just plain works. However, the Navigation Bar can and does still serve a purpose. Most application still use it to display the Logout link and perhaps the name of the currently signed (more...)

Oracle Spatial (Teil 3) – Entfernung von Punkten berechnen

Im heutigen Blogpost möchte ich kurz anhand eines Beispiels aufzeigen, wie Sie die Entfernung von SDO_GEOMTRY Punkten berechnen können. Hierbei gehe ich auch konkret auf das Problem des Verbindens von zwei Datenmengen anhand einer definierten Entfernung ein.
Mehr »