Expert Oracle APEX 2nd Edition

Just submitted first of my two chapters (Tabular Forms) for the new Expert Oracle APEX 2nd Edition. The chapter is covering the most important practices in Tabular Form handling. Also, a couple of neat features like cascading select lists in Tabular Forms - this time using standards only. Still not sure when the book will be published but it should happen soon.

 Follow on Twitter

Enable Real Application Security (RAS) in APEX 5.0

Oracle Database 12c introduced Oracle Real Application Security (RAS), the next generation Oracle Virtual Private Database (VPD). In APEX 5.0 RAS is declaratively build-in. Follow the below steps to enable it:

Login to the INTERNAL workspace and go to Manage Instance > Security:

In the Real Application Security section set Allow Real Application Security to Yes.

Next login to the Workspace your Application is build in and go to your Authentication Scheme.
You'll (more...)

APEX im Jahr 2015

Mit dem erscheinen von APEX 5 dreht die Community jetzt so richtig auf.

Neben der APEX Connect im Juni (bis 08.05. Frühbucherrabatt) wird es schon einen Monat später eine Reihe von APEX 5 Webinaren unter dem Motto #apexsummer15 geben.



Was mir bei den ganzen Aktivitäten auffällt, ist der starke Community Faktor. Umso mehr wundert es mich, dass sich nach Veröffentlichung von APEX 5 keine große IT-News Plattform intensiver mit der Materie befasst (more...)

APEX 5.0 Summer School 2015

Es tut sich ganz schön was in der APEX Community dieses Jahr. APEX 5.0 wurde veröffentlich. APEX Connect im Juni findet statt und sollte bisher der größte APEX-Treffen im deutschprachigen Raum werden. Nun, wurde auch eine Reihe an Webinaren organisiert - APEX 5.0 Summer School - für alle, die keinen Urlaub machen oder für diejenigen, die den Urlaub langweilig finden. Meldet euch an. Die Anzahl der freien Plätze ist nicht unendlich.

APEX Summer School 2015 – Online Webinare

Im Rahmen der APEX Summer School 2015 ( Twitter Handle: #apexsummer2015 ) werden wir 9 kostenlose Webinare zum Thema APEX 5 mit den Experten aus dem deutschsprachigen Raum durchführen:



Vielen Dank an Carsten Czarski für die Einladung und Organisation! Nicht zuletzt auch vielen Dank für die klasse Homepage des Webinars, alles 100% APEX 5 out-of-the-box! Ein einfaches und dennoch wirkungsvolles Beispiel dafür, was standardmäßig mit APEX 5 möglich ist:

APEX 5 ist seit letzter Woche (more...)

Destroying The Moon

Just under three years ago, I joined Enkitec when they acquired Sumneva.  The next three years brought a whirlwind of change and excitement - new products, additional training, and expanding the APEX practice from an almost nonexistent state to one of the best in the world.

Like all good things, that run has come to an end.  Last Friday was my final day at Accenture, and I am once again back in the arena of (more...)

Upgrading to Application Express 5.0 in Your Oracle Database Release 12.1 Multitenant Container Database (CDB)

Woo hoo! Oracle Application Express 5.0 has been released. Read all about it here.

The purpose of this blog post is to provide information on how to upgrade your 12.1 Multitenant Container Databases (CDBs) to APEX 5.0, and specifically ones where you have Oracle Application Express installed in CDB$ROOT (the root), and you are making use of Oracle Application Express 4.2.x in the PDBs in this CDB. There has been (more...)

JSON for APEX Developers (part 3): Querying JSON in Oracle DB 12c

In previous blog posts I talked about JSON for APEX Developers:
In this post I want to show how you store and query JSON data straight in the database.

To start, create a table to store the JSON object:

CREATE TABLE ssn_json
   (id          NUMBER GENERATED ALWAYS AS IDENTITY NOT NULL,
    date_loaded (more...)

Oracle APEX 5.0 released today

After 2.5 years of development, today is the day APEX 5.0 is publicly released and ready to be downloaded to install on your own environment.

In my view it's the best release ever. Not so much of the new Page Designer - although that is definitely a piece of art and it increased productivity even further - but because it's the first time whole of APEX got refreshed and every piece was put (more...)

Oracle Application Express 5 – The Unofficial Announcement

What started on a whiteboard in New York City more than 2 years ago is now finally realized.  I and the other members of the Oracle Application Express team proudly announce the release of Oracle Application Express 5.

The official blog posting and announcement is HERE.  But this is my personal blog, and the thoughts and words are my own, so I can be a bit more free.

Firstly, I don't ever want to see (more...)

APEX 5.0 IST DAAAAAA!

Endlich ist es geschafft.

Wen interessiert Heute die Champions League, wenn du Oracle APEX 5 downloaden kannst:
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html



Oracle Application Express 5.0 now available

The result of a two and half year engineering effort, Oracle Application Express 5.0 represents the greatest advancement of Oracle Application Express in its 10-year history.  Oracle Application Express 5.0 enables customers to develop, design and deploy beautiful, responsive, database-driven desktop and mobile applications using only a browser.  



Now that APEX 5.0 is finally available, it’s time to spread the word and to get everyone up (more...)

Oracle APEX 5.0 Available for Download!

After a longer development cycle than usual, Oracle Application Express 5.0 is finally available for download! I think it was worth the wait. It comes with a ton of features, here are just a few marquee features. Page Designer Universal … Continue reading

APEX 5.0 will be released today

Great news. Just finished wathching the Google hangout with the APEX team. They confirmed that APEX will be released today. The download should be made available soon. Stay tuned.

APEX 5.0: Set Cursor Focus for Region Type Plug-Ins

Complex Region Type Plug-ins might render their own input fields, like our Interactive Report component does with the search field. If a developer had set the page level attribute Cursor Focus to First item on Page in Oracle APEX 4.x, … Continue reading

APEX 5.0: New Plug-in Attribute Types

Besides the Plug-In Attribute Enhancements described in my previous posting, we have also added new Attribute Types in Oracle APEX 5.0 for increased usability in Page Designer. Link to Target Page/Url If your Plug-in had to exposed a Link attribute … Continue reading

Ask the Real Experts

On Wednesday you will have a chance to ask the APEX developers anything you would like to know about APEX 5.0. See this posting from Patrick Wolf or go directly to the registration form in order to get a link.

APEX 5.0: Plug-In Attribute Enhancements

In Oracle APEX 5.0 we have added several new features to Custom Plug-in Attributes to improve the usability of your Plug-ins when they are used by other developers. Show in Wizard Some Plug-ins do make use of the maximum number of 25 … Continue reading

APEX CONNECT: Noch 59 Tage (1.428 Stunden)

Die APEX CONNECT rückt immer näher.

Viele Vortragende erstellen ihre Vorträge immer kurz vor knapp. Da ich aufgehört habe APEX mit Hilfe von PowerPoint zu präsentieren, muss ich jetzt schon loslegen um Stück für Stück die optimale Präsentations-Beispiel-Anwendung aufzubauen.

Meine Präsentation wird sich um die maßgerechte Verwendung von APEX Plug-Ins drehen.
Details zum Vortrag:


Ziel ist es, einen realistischen Blick auf Plug-Ins zu vermitteln und Ihnen die atemberaubenden Möglichkeiten, aber auch die Gefahren anhand von (more...)

Slides from my presentation at APEX World 2015 in Rotterdam

Hi guys,

I had a great time at APEX World in Rotterdam, it was a wonderful event. I could meet up with my friends and learn a few new tricks, too :).

Here are the slides from my presentation about the many smaller new features of Oracle APEX 5.0. And I could only cram like half of the good stuff that I found into this 45 min. session.

About 70 people attended the (more...)