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

APEX 5.0: Declarative Definition of CSS and JavaScript Files to Load for a Plug-in

A best practice for performant HTML pages is to load CSS files in the HTML head to reduce redrawing of the page when a CSS file gets loaded. But because the PL/SQL code of a Plug-in isn’t executed util a … Continue reading

APEX 5.0: Directory Support for Static Plug-in Files

Since day one, the APEX Plug-in framework provided the capability to create self containing installations which included all static files needed by the Plug-in. But this file storage was somehow limited in APEX 4.x, because it didn’t allow to reference files with … Continue reading

APEX 5.0: Want to learn all about Universal Theme?

And do you want to learn it straight from Shakeeb Rahman the Designer of the Universal Theme? Then you have to sign up for the free ODTUG Webinar on Thursday, April 9 at 12:00PM EDT. That’s 17:00 London, 18:00 Vienna … Continue reading

APEX 5.0: Create Plug-ins as Subscription from Master Application

In APEX 4.x it was a little bit cumbersome to use new Plug-ins in an application when you followed the best practice to subscribe Plug-ins from a Master Application which contained all Plug-ins of your workspace. Having such a Master Application has … Continue reading

APEX 5.0: Plug-in Enhancements – Overview

In the next few days I plan to write a series of blog postings about the Plug-In Enhancements which will be available in Oracle APEX 5.0* The plan is to cover the following areas: Create Plug-ins as Subscription from Master … Continue reading

Oracle APEX 5.0 Articles

With apex.oracle.com upgraded to a pre-production version of Oracle Application Express 5.0, the new release of APEX can already be seen on the horizon. So I thought it’s time to compile a little weekend reading for you.   A number of … Continue reading

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