view counter


Oracle Application Express (APEX) resources, news, and support articles.

APEX - Default Branch on Submit

Yesterday I spent two hours on debugging one of my applications and searching for an answer. Of course, the problem was caused by myself. Here is what happened:

I copied a page and deleted the region including buttons and items using the Cascade to Delete Buttons option.

My Oracle Openworld APEX Sessions

Oracle Openworld 2014 is just around the corner (it’s still not too late to register) and I’m going to be presenting a couple of sessions -

APEX 5.0 New Features Schulung

Unsere nächste Schulung hat APEX 5.0 New Features im Fokus. Diese findet im Dezember am 08. und am 09. in Bensheim statt. Wenn Sie auf diesen Link klicken, können Sie die Details anschauen und sich ggf. anmelden. Dieses Thema is sehr spannend und viele neue Features bzw. Änderungen kommen auf uns zu. Wir denken, dass Dezember der richtige Zeitpunkt dafür ist, damit anzufangen.

DOAG 2014 - Vortrag zum Thema: Dynamisches Arbeiten mit Grafiken in APEX

Mein diesjähriger DOAG Vortrag ist am letzten Konferenz-Tag  
20.11.2014 um 9:00 (Raum Istanbul)


Auf was könnt Ihr euch freuen?
Ich zeige einen Lösungsansatz mit dem man Grafiken dynamisch nutzen kann, ohne viel Programmieraufwand zu investieren.


Calculate minutes between two dates

Simple question but always a pain in the ass in finding the right solution:

(to_date('12.08.2014 12:30',' hh24:mi')
-to_date('12.08.2014 11:30',' hh24:mi')
) * 24 * 60
,0) as result_in_minutes
from dual;

Set Focus on Added Row Tabular

This sounds quite simple:

"I would like to set focus on the new added row in my tabular form."
In the following example, you can se how to acomplish that.

Cascading Shuttle - Keep Selected Values

There are probably a several good ways to solve the following problem:

    1. you have a simple select list which cascades a shuttle element
    2. you select something and the shuttle is populated
    3. after that, you pick a value in the shuttle and move it to the rigt side
    4. then you change the select list again
    5. the values you selected in your shuttle are now lost

This example shows how this can be done.

jQuery - loop through a Tabular Form

This question is one of the frequently asked questions - "How do I loop through a tabular form using a dynamic action?". This example shows how to loop through a tabular form and set the values for each row to what ever you want. Using apex_application.g_fxx array is not an option for onload processes or dynamic actions. It can only be used in an on submit process. Using jQuery in a simple loop it is possible to read / set any of the values in any column. Try it out.

OTN APEX Forum again

The OTN Forum is not available (again). This usefull but constantly changing forum now gives me the following message:

I am not sure why they are using jive for that. Maybe APEX would be a better solution.

view counter