Generierung von Bitlisten mit Hilfe von SQL am Beispiel einer Datum zu Monat Konvertierung

Ich hatte vor kurzem die Aufgabe erhalten eine Bitliste auf Basis eines Monats zu generieren.
Bedeutet, ich habe einen String mit 31 Zeichen der je Zeichen den Zustand 1 oder 0 einnehmen kann.
 - 1 steht für aktiv
 - 0 steht für inaktiv

Beispieldaten:
'0000000001010001000000000000000'
'0000000000000000111111000011010'

Um dies anhand eines verständlichen Beispiels zu verifizieren, habe ich mir eine Dienstplan-Tabelle ausgedacht.
Mehr »

APEX 5 Migration – Part 1 – Requirements and Installation

During this year I have done several APEX 5 migrations and I held three lectures on the topic.
Unfortunately it only reached out in Germany, however the content would contribute to simplifying the work for everyone. So I decided to blog it. I will cover this topic in three different posts:
- Requirements and Installation
- Common issues after the migration
- Universal Theme migration

I start with the requirements and installation of APEX 5.
(more...)

Oracle JET Charts – Do we need alternatives anymore?

After I looked through the chart types supported by the new Oracle JET framework I asked myself if we need other chart plugins like D3JS or RaphaelJS in future APEX releases anymore?

The answer is: Yes in special cases.

My supposition is that we can use all available JET charts in one of the next versions of Oracle APEX.

Now I will describe the "special case" with two examples where other chart frameworks still make sense:
Mehr »

All JET charts in APEX 5.1

I added a new feature request for APEX:
APEX 5.1 with support for all available JET Data Visualizations Charts

Description:
APEX 5.1 will include a new charting engine based on the new Javascript Framework "Oracle JET". Unfortunately APEX 5.1 will only include those charts from the JET website (http://www.oracle.com/webfolder/technetwork/jet/uiComponents-dataVisualizations.html) which are supported in the current version of APEX. For example the "Spark Chart" or the "Timeline" will (more...)

SQL: Calculate the past time between two dates in percent

Just a simple example how easy APEX can handle this kind of problem.

Example:
We have today the 06.11.2015 (11-06-2015) and we have two date values 01.11.2015 and 30.11.2015.
Now I want to know how much time has past in percent since the beginning (01.11.2015):
Result: 17 %
Mehr »