Creating interactive graphics in APEX with Raphaël (RaphaelJS)

Some of you may know of my personal interest for SVG interaction in APEX applications. I have been working with a JavaScript library called "Raphaël" (RaphaelJS, raphael.js or just raphael) for a while now. It is an amazing plugin to create all kind of customized business solutions. But before I show you how I have used Raphaël I tell you how I came to the technology and what happened in the last few years.


Oracle APEX Meetup in Stockholm 16.08.

In my summer holiday, this year in Stockholm (Sweden), I will make a stop and present two APEX topics in the "Stockholm Oracle Meetup group".

The topics will be:

Working with interactive SVG graphics in APEX 
Adding SVG graphics inside individual business applications is quite in common. Because those graphics can increase the usability and even more important it creates a completely new way to visualize data inside a browser app. In this presentation he (more...)

Interactive Report with a Font Awesome edit icon

Most of you know the default APEX edit icons you can choose from inside your Interactive Report.
Basically you use them to link to a detail page.

The icon source looks like this.

A typical result page.

Two things I would like to change:
 1. The Icon should be a nice looking car symbol from the Font Awesome library.
 2. The column width should be as small as the icon and not relative to the (more...)

Reset Interactive Report (IR)

Resetting an Interactive Report (IR) can be done in 4 different ways.
User Reset, URL Link, Page Process, Dynamic Action

First of all
It is always a good start to set up a specific static report id.

1.  User Reset
Not much to say.

1. URL Link


Cache definition:
- RIR: reset IR to primary report
- CIR: reset IR to primary report but with custom columns

Oracle Spatial (Teil 4) – Unterschiedliche Koordinaten Punkte zu einer Linie zusammenführen

Vor kurzem musste ich Daten aus einer Excel-Liste in das SDO_GEOMETRY Format bringen. Leider hatte die Excelliste einen Haken.

Die Anforderungen:
- Es musste eine Linie (Typ 2002) im GK3 Format (31467) aus VON und NACH Punkten generiert werden.
- Die Excel-Liste hatte die Punkte entweder als GK3 oder als WGS84 Format hinterlegt.

Nach Import der Daten sah meine Quelltabelle dann so aus:

Und hier das Select zur richtigen Transformation der Geo-Daten ins SDO_GEOMETRY Format:

APEX Master (Interactive Report) – Detail (Modal Dialog) Form: Conditional Column Link

Since APEX 5 it is much easier to create master-detail pages with modal dialogs. But there is still no declarative way to create a conditional row based column link.

This blog post will show you a way how to create a conditional row based master - detail page.

1. We need some sample data:
select 1 as ID, 'APEX Connect' as name, 1 as CONDITIONAL_COL from DUAL
union all
select 2 (more...)

Using dynamic tooltips in your Interactive Report

Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be automatically trimmed if more then 60 characters were displayed. If the user moved the mouse above a trimmed comment then a tooltip should be display including all comment text.

My first idea was to check for existing plugins which could do this job for me. So I searched (more...)

The APEX CONNECT and the APEX dashboard competition 2016

Before I tell you about the APEX dashboard competition winner I want to share my impressions from the APEX CONNECT 2016 in Berlin with you.

We had 3 days fully packed with APEX, SQL, PL/SQL, SQL Developer and different JavaScript technology topics.

In every way Niels de Brujin, Carsten Czarski, Christian Schwitalla and the whole DOAG team created an amazing event and has raised the quality compared to the last year.

We had more attendances, (more...)

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 »

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...)

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...)

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...)

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 »

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 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 »

UILayout for Universal Theme

Some of you may know the plugin "UILayout for APEX" I developed in 2011. It is based on the jQuery plugin called "UI Layout"

I'm currently develop a new version running only inside the Universal Theme (UT).  This version is completely redesigned and focused only to work with the UT.

Actually it is quite cool because it supports some really handy features:
Mehr »

APEX Dashboard Competition News

In this blog post I will provide news, questions and problems about the dashboard competition which were published by Twitter.
You can follow Twitter yourself searching for this hash tag: #apexcompetition

Language forwarding on

The APEX page was developed using two pages.
One for the German speaking community and one for the English speaking APEX developers.

Normally you would create an application and translate the text parts after you finished the development. With we developed a one page application. Instead of translating the page we decided to create a copy of the page and translate this one instead. In the end we had one for (more...)

APEX Dashboard Competition

Liebe APEX Community,

ich bin froh nun endlich die nächste große Sache präsentieren zu können. Wir veranstalten eine APEX Competition nach dem Vorbild der APEX Gaming Competition.

Erschafft eine APEX Dashboard Anwendung.

Kurz zusammengefasst:
Erstellt bis zum 01.04.2016 eine APEX Universal Theme Anwendung mit einer Seite die auf Basis eines vorgefertigten Sets von Daten, die ultimative Dashboard Erfahrung liefert.

Was bringt euch die Teilnahme?
Es gibt geniale Preise vom ersten bis zum zehnten (more...)