My "Must See" ADF/MAF Sessions at KScope 16

Yes, you read that right - it's not a typo, nor did one of my kids or wife gain access to my laptop.  It's part of a "blog hop" - where a number of experts made recommendations about KScope sessions that are "must attend" and are not in their core technology.  I picked ADF/MAF, as I don't have any practical experience in either technology, but they are at least similar enough that I would not (more...)

Please, use HTTPS for your APEX apps

Why use HTTPS?

When you Google this question you get many different answers, but this answer of Google Developers answers it for me in short (click the link for more details):
  • HTTPS protects the integrity of your website/APEX app
  • HTTPS protects the privacy and security of your users
  • HTTPS is the future of the web; many new technologies only work with https (for example Service Workers; you can read more about Service Workers and APEX (more...)

The APEX CONNECT and the APEX dashboard competition 2016

Before I tell you about the APEX dashboard competition winner I want to share my impressions from the APEX CONNECT 2016 in Berlin with you.

We had 3 days fully packed with APEX, SQL, PL/SQL, SQL Developer and different JavaScript technology topics.

In every way Niels de Brujin, Carsten Czarski, Christian Schwitalla and the whole DOAG team created an amazing event and has raised the quality compared to the last year.

We had more attendances, (more...)

Slides and demo script from my APEX command line scripting talk at APEX Connect 2016 in Berlin

Hi everybody,

I just came back from the DOAG APEX Connect 2016 conference in Berlin ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure. This time we felt a little pinkish ;)

As promised, you can download the slides and the demo script (as is) from my site. They are in German, but I will give the talk in June at KScope 2016 in Chicago in English (more...)

Slides and demo script from my ORDS talk at APEX Connect 2016 in Berlin

Hi everybody,

I just came back from the DOAG APEX Connect 2016 conference in Berlin ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure. This time we felt a little bit pink ;)

As promised, you can download the slides and the demo script (as is) from my site.

Instructions are included.

See you at KScope in Chicago, #letswreckthistogether .

Cheers and enyoy!
~Dietmar. 


Web technology in APEX Development

How did you get started with developing your first APEX app? 

My guess is either you went to https://apex.oracle.com and got a free account or Oracle Application Express was already in your company and somebody told you the url you could connect to. For me that is really the power of APEX, you just go to an url and within minutes you created your first app.

Staying within the APEX framework?

With (more...)

My Presentation at APEX Connect 2016

On 28th of April I will be presenting at APEX Connect in Berlin. The topic is Integration of APEX with HERE Maps. If you are interested to see how you can integrate APEX with Maps (HERE or Google or some other) please join the presentation. The best thing is that this integration ist done using APEX Plugins only. I will try to show as many functionalities as possible including Routing, Tracing, Positioning and a combination (more...)

An Important Change Coming for Oracle Application Express in Oracle Database 12cR2

A minor but important change is happening for Oracle Application Express in the forthcoming Oracle Database 12cR2.  Specifically, Oracle Application Express will not be installed by default in the Oracle Database.  This change was made specifically at our request.  We thought the pros far outweighed the cons, and we thought this was good for our customers and consistent with our recommendations.


Pros

  1. Provides flexibility for a DBA to run multiple APEX versions in an Oracle (more...)

My Demo Application

If you experience a problem accessing My Demo Application (old and new version) at apex.oracle.com, that means there is a reason for that. One of the users deleted all the applications in my workspace and installed some of his own. I don't think this was intended but it is still a lot of work and I am trying to geta all the important stuff back online. After that I will need to rethink (more...)

New APEX training in Vienna – APEX Debugging and Performance

Just a quick note: I’ll be holding a 1-day APEX training class on April 21st in Vienna, Austria.

In this training I’ll teach you how to debug your APEX applications, how to find problems and bugs and how to speed up your application.

Interested? Go here and sign up: http://www.aoug.at/Event/413

How to update a custom public theme in Oracle APEX

In the last post I showed how you can upload a custom theme to the instance repository so that all your developers can choose that theme within the create application wizard. And more importantly, subscribe that theme from the theme repository.

Now the next question is how to update that public theme so that all applications can inherit the changes.

My first attempt was to simply go to Instance Administration – Manage Instance – Public (more...)

Creating a custom public workspace theme

The Universal Theme introduced with APEX 5 is immensly good looking and comes with a powerful Theme Roller to customize it.

With that new theme most, if not all, older themes are obsolete.

That leaves us just with a few corporate designs which can’t (or don’t want to) be replaced by the UT.

Now ideally you want your developers to use that custom theme in all applications and also subscribe to that.
Historically I recommended (more...)

Me and the ODTUG Board

This afternoon my Twitter timeline exploded with retweets, likes and congratulations. It all started with this tweet:

So it's official now. As Sarah Zumbrum had to step down due to her (dream) move to Oracle, a position on the ODTUG board opened up. And I was asked whether I was still interested. And of course I was! So after an internal voting procedure, I received the good news last weekend - and had to keep (more...)

Slides and demo script from my ORDS talk at apex.world 2016 in Rotterdam

Hi everybody,

I just came back from the apex.world conference in Rotterdam ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure.

As promised, you can download the slides and the demo script (as is) from my site.

Instructions are included.

See you at APEX Connect in Berlin or KScope in Chicago, #letswreckthistogether .

Cheers and enyoy!
~Dietmar. 



Add browser recognition on page inline CSS

Today I will show a code example how you can add browser recognition inside the "Inline CSS" mask of your APEX page.

Mehr »

APEX 5 – Opening and Closing Modal Window – Part Two

In this blog post from 2015 I explained how to open a modal window from an item and pass the values back, display a sucess message, etc. This page also contains an item plugin to make it easier to do the whole stuff and avoid hardcoding. I have never published this plugin. Hopefully this functionality is going to be a standard part of 5.1. Now, I was asked to make this working with a (more...)

CREATE an APEX_COLLECTION and SELECT the data via SQL Developer

Maybe this an old hat but a lot of people don't know how to use and analyze APEX_COLLECTION properly.  For myself it is a good reminder and saves me about 2 minutes instead of googling around.

In this example I will show you how to
- create an APEX_COLLECTION
- select the data in APEX reports
- analyze APEX_COLLECTION in SQL Developer

I will only show some basic steps. For a more detailed explanation (more...)

Change Item Position using jQuery

See this example on how to change the item position. In APEX you can position the buttons after the action bar in an interactive report. However, you can't put the items there. Using jQuery this is easy to achieve.

React on Tab Change

See this example on how to react on tab change in APEX 5. The problem is to determine the right selector to trigger the corresponding dynamic action. Thanks Christian Rokitta for your help.

Fragen rund um die APEX Dashboard Competition

In den letzten Tagen wurden mir mehrere Fragen rund um die APEX Dashboard Competition gestellt. Die Fragen und Antworten möchte ich gerne teilen:

Frage:
In wieweit darf man das Universal Theme verändern? Darf die Anordnung der Regions geändert werden? Darf das Menü links entfernt werden?
Antwort:
Sie können mit dem Universal Theme machen was Sie wollen.
Einzige Einschränkung: Das Theme sollte nicht unter einer anderen ID abgespeichert werden. Dann wäre es ein Custom Theme und (more...)