Oracle Application Express 5.0.2 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.2, you can get it from the Downloads page on OTN.
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.
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. You can read more about it on Lino's blog.
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.
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.
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:
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.