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

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

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

Oracle Database Development Tools (ODDT) 2015-03-23 19:41:00

If you haven't done so checkout the Oracle APEX universal theme packaged application on apex.oracle.com.  Here it is from inside a Tesla on a crisp 17" touchscreen.  Yes it does work while driving.




apex.oracle.com – Upgrade to APEX 5.0

It is time to get used to the new APEX builder interface. apex.oracle.com has been upgraded to the latest pre-production version of APEX 5.0. Some functionality like "Administration" are not visible any more and you have to search a bit. The overall impression is good and my old demo application seem to still work in the most of the cases.



Enjoy.

apex.oracle.com has been upgraded to a pre-production version of Oracle APEX 5.0

If your an Oracle APEX developer you will want to try http://apex.oracle.com.  We have just upgraded this free service to a close (but not yet) production version of Oracle APEX 5.0.  If you already use apex.oracle.com login and validate your applications work as before.  If you don't have an account create one; it should take less then a minute.

Oracle APEX 5 has a new feature called "Universal Theme".  A (more...)

Read Only Item Layout

The possibility to set the items conditionally to read only is one of the important security features in APEX. Using this feature you can secure your applications and it will not be possible to manipulate the protected item (region or page). The downside of this feature is that it will change the layout of the protected items to some kind of standard, ignoring the previous formatting in the "normal" mode. If you have a form (more...)