view counter


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

Analytische Funktionen (Teil 1): SUM mit CASE WHEN

Es gibt wie in meinem letzten Post beschrieben, sehr viele Artikel zu analytischen Funktionen. Diese zeigen die Fähigkeiten aber nur an der Oberfläche. Deshalb möchte ich in den nächsten Monaten die besten Tricks mal beispielhaft abbilden.

Custom image on your APEX app login page

In a comment on my post APEX 5.0: pimping the Login page I got a question how to put your own logo or a custom image on the login page, instead of an icon.

You only need a bit of CSS to do the trick:

Die besten HowTo's rund um fortgeschrittene SQL-Techniken

Im Zuge des aktuellen Community Tips, möchte ich mal eine Liste an HowTo's, Tips und Tricks rund um die verschiedenen aktuellen


Having just re-read quite a few of my previous blog posts (especially the last two), I can see that over the last while I’ve been a bit restless and unsettled.

Looking back over my career recently I realized that I've been doing consulting for probably 20+ of my 28 year tenure. I don't regret any part of it as it's taken me all over the world, introduced me to some amazing people and given me hundreds of memorable work and personal experiences.

But if I look at the last 10 years, the things that I've most enjoyed have not been consulting. For instance:

ORDS... Yes we can!

On September 13th I got a nice surprise, an email of Steven Feuerstein with the message: "You have been selected as a finalist in the ORDS category for the 2015 Oracle Database Developer Choice Awards!"

It's always nice to get recognition for the efforts you do, so thanks so much already for the nomination. I didn't make publicity yet in order to get some up-votes, but I hope by reaching out to the people who read my blog, I gain some more up-votes :)

Oracle Spatial (Teil 2) - Füllen der USER_SDO_GEOM_METADATA

Damit Tools wie
  - Oracle Spatial Reader
  - FeatureReader
  - OracleQuerier

mit Oracle Spatial Tabellen arbeiten können, müssen diese in einer Meta-Schicht bekannt gemacht werden. Dies ist im Prinzip ganz einfach, denn dazu muss nur die View USER_SDO_GEOM_METADATA gefüllt werden.

Die View beinhaltet die folgenden Spalten:

Oracle Database Developer Choice Awards

Don't forget to vote for the expert of your choice at There are a lot of good men there deserving your voice for their activities in the community and for their selfless engagement.

Drop It Like It's Not

I just ran the following script:

FOR x IN (SELECT table_name FROM user_tables)

My Nomination for the Oracle Database Developer Choice Awards

Actually this came as a wonderful surprise ...

If You're In Latvia, Estonia, Romania, Slovenia or Croatia, Oracle APEX is Coming to You!

In the first part of October, my colleague Vlad Uvarov and I are taking the Oracle APEX & Oracle Database Cloud message to a number of user groups who are graciously hosting us.  These are countries for which there is growing interest in Oracle Application Express, and we wish to help support these groups and aid in fostering their growing APEX communities.

The dates and locations are:

view counter