I Had Low Expectations for the APEX Gaming Competition 2015 from ODTUG. Wow, Was I Ever Wrong!

When the APEX Gaming Competition 2015 was announced by Vincent Morneau from Insum at the ODTUG Kscope15 conference this past year, I was very suspect.  I've seen many contests over the years that always seemed to have very few participants, and only one or two people would really put forth effort.  Why would this "Gaming Competition" be any different?  Who has time for games, right?  Well...I could not have been more wrong.

I was (more...)

Presentation slides for my presentation at DOAG 2015 – Apache – ORDS Setup for Production Environments

Hi guys,

here you can find the slide, the config files and installation steps for my presentation at the DOAG conference in Nürnberg on 18.11.2015:




Oracle JET Charts – Do we need alternatives anymore?

After I looked through the chart types supported by the new Oracle JET framework I asked myself if we need other chart plugins like D3JS or RaphaelJS in future APEX releases anymore?

The answer is: Yes in special cases.

My supposition is that we can use all available JET charts in one of the next versions of Oracle APEX.

Now I will describe the "special case" with two examples where other chart frameworks still make sense:
Mehr »

Refreshing PL/SQL Regions in APEX

If you've been using APEX long enough, you've probably used a PL/SQL Region to render some sort of HTML that the APEX built-in components simply can't handle. Perhaps a complex chart or region that has a lot of custom content and/or layout. While best practices may be to use an APEX component, or if not, build a plugin, we all know that sometimes reality doesn't give us that kind of time or flexibility.

While the (more...)

APEX 5 Cheat Sheet

On Twitter today, Jeff Smith tweeted about a new SQL Developer cheat sheet that he created with a site called cheatography.com.

Not to be outdone, I created a cheat sheet for the APEX 5 Keyboard Shortcuts. Not only can you view it online, but you can also download a PDF version of it. Check it out and let me know if there's anything that you'd like to see added.

I *almost* made it to the ODTUG Board of Directors …

Last month was the annual election for the Board of Directors of ODTUG. And just like the year before, I was one of the 19 (!) candidates for one of the 5 spots. 
During the campaign and election periods I received a lot of positive feedback and my hopes were high - but the competition was extremely strong. During Oracle Open World the results were announced and I was notified I hadn't made (more...)

All JET charts in APEX 5.1

I added a new feature request for APEX:
APEX 5.1 with support for all available JET Data Visualizations Charts

APEX 5.1 will include a new charting engine based on the new Javascript Framework "Oracle JET". Unfortunately APEX 5.1 will only include those charts from the JET website (http://www.oracle.com/webfolder/technetwork/jet/uiComponents-dataVisualizations.html) which are supported in the current version of APEX. For example the "Spark Chart" or the "Timeline" will (more...)

SQL: Calculate the past time between two dates in percent

Just a simple example how easy APEX can handle this kind of problem.

We have today the 06.11.2015 (11-06-2015) and we have two date values 01.11.2015 and 30.11.2015.
Now I want to know how much time has past in percent since the beginning (01.11.2015):
Result: 17 %
Mehr »

Kostenpflichtige Erweiterungen für APEX

Bei dem letzten APEX Meetup in Frankfurt kam eine Frage zur Erweiterbarkeit von APEX auf.
Hierbei ging es darum zu klären was sich besser eignet:
  - Kaufsoftware
  - Opensource Software
  - Eigenentwicklung

Die Frage was sich besser eignet hängt von unterschiedlichen Faktoren ab, die ich nicht Heute im Detail erklären werde.

Ziel im heutigen Blogpost ist es, eine vollständige Liste an möglicher Kaufsoftware Erweiterungen für APEX aufzuzeigen, ohne eine Wertung der jeweiligen (more...)

Pager Designer Plugin Xplug

The new APEX Page Designer is a great tool in doing your development work faster then ever. Actually I only discovered two more or less annoying things so far.

1. Doing "mouse miles" from the left side to the right side.
The new Grid Layout takes much space especially on the big screens. When you access an item on the left side you need to move your mouse to the right and edit the stuff (more...)

Was ist Oracle JET

Oracle JET ist das neueste Oracle Development Werkzeug mit dem Ziel moderne Webapplikationen auf Basis von Javascript zu bauen.

Die Grundlage dafür bildet ein eigens dafür entwickeltes JavaScript Development Framework das zusätzlich um mehrere mehr oder weniger bekannte OpenSource JS Frameworks (jQuery, RequireJS, Knockout und weitere) erweitert wurde.

Witzigerweise scheint Oracle JET nicht allein zu sein, denn die Abkürzung bezeichnet innerhalb des Oracle Toolsets zwei unterschiedliche Technologien.
Das neue Oracle JET (JavaScript Extension Toolkit) und (more...)

Hide and Seek

In migrating SERT from 4.2 to 5.0, there's a number of challenges that I'm facing. This has to do with the fact that I am also migrating a custom theme to the Universal Theme, as almost 100% of the application just worked if I chose to leave it alone. I didn't. More on that journey in a longer post later.

In any case, some of the IR filters that I have on by (more...)

Page Designer bug in combination with APEX plugin settings

Yesterday evening I struggled with a strange issue inside the Page Designer.

One APEX application created on each page of the Page Designer the following javascript parsing error:

Error: parsererror - SyntaxError: JSON.parse: unexpected end of data at line 1 column 1 of the JSON data

It only happened in 1 of several applications I currently check after an APEX 5.0.2 migration.

What I did to find the issue (Thanks to Denes (more...)

Custom jQuery dialog and APEX 5 z-index bug

After migration to APEX 5.0.2 I got an issue with a custom jQuery dialog (similar to this one).

The modal dialog wasn't accessible because the overlay effect was on top of my dialog as well.

Luckily some CSS code fixed the issue:

body div.ui-widget-overlay {
    z-index: 1;

Btw.: The return to page function didn't work in the "edit page" view.

Universal Theme Face Lift

I'm a huge fan of APEX's new Universal Theme, and have been working quite a bit with it.  One of the coolest features is how easy it is to change the colors.  You don't even need to be good at design - just click Theme Roller, and spin all the things!

However, as much as you change the colors, the look and feel still largely looks the same, since the base font is unchanged.

So (more...)

Custom CSV Export as ZIP file

At the beginning of this year I wrote an article about "Custom CSV Export in APEX".

Now I want to extend the solution by an optional ZIP export.

You can not export several files at the same time with standard APEX features. For that you have to create a ZIP file including all the files you want to download.

I made an example application "Multi CSV Download as ZIP file" where you see a (more...)

Die APEX Community gibt Vollgas!

Am Montag dem 19.10. wurde getrieben von Jürgen Schuster und weiteren APEX Entwicklern die apex.world Plattform veröffentlicht.

Eine nur von der APEX Community entwickelte und betriebene Plattform, die die Kommunikation und Zusammenarbeit zwischen Entwicklern drastisch vereinfachen und verbessern will.

Die Highlights:
 - eine LIVE Integration von Slack und Twitter
 - Die APEX Job Börse
 - Plug-In Bereitstellung mit Hilfe von GitHub
 - APEX Terminübersicht zu Meetups, Konferenzen und Live Webinars
 - APEX Einsteigerbereich (more...)

Select all Checkboxes in IR – APEX 5

If <input type="checkbox" onclick="$f_CheckFirstColumn(this)"> doesn't work for you in APEX 5 Interactive Reports then you will need to disable Fixed Headings (standard). Fixed headings splits the report into two tables and the function won't work.

Oracle Live SQL

Oracle Live SQL is a great source for learning SQL and PL/SQL. It has a lot of good examples and interactive educational tutorials. The best thing is, it runs on APEX ;) Add this site to your bookmarks.

SQL Probleme und das Oracle SQL Forum

Viele meiner Kollegen (um die 90 %) nutzen bei schwierigen SQL Problemen nicht das SQL Forum, sondern versuchen sich lieber an inperformanten PL/SQL Code.

Die Gründe sind leicht erklärt: Zeitmangel!

Der kurzfristige Vorteil kann im Nachhinein aber sehr teuer / zeitaufwendig werden. Nämlich dann, wenn die schnelle Lösung mit erhöhten Datenmengen versagt und statt ursprünglich wenigen Sekunden plötzlich Minuten an Zeit verbraucht.

Hierbei möchte ich auf die goldene Regel von Tom Kyte referenzieren:
     1. (more...)