Oracle VM Site Review - Oracle VM Health Check
view counter


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

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.

OTN APEX Forum Link

Oracle again changed the layout of the forum. For me, the old link didn't work any more. In case you have problems finding it, here is the new link:

If you go to the forum and search for example for "APEX" or "Application Exp", you will see no results. Typing in "Application Ex" will find "Application Express".

Format Lower/Upper with SQL Developer

There is a simple trick to format your SQL code in LOWER,UPPER,INITCAP with SQL Developer.

Select the code you want to format and click the "Aa"-button or "Strg + Quote".


APEX Datei Download - Sicher und Einfach

Weil ich gerade selbst wieder im Internet nach der richtigen Lösung gesucht habe.
Hier der einfachste und bestbeschriebenste Weg wie Sie Dateien (über beispielsweise einen Report)  downloaden können:

Take a Walk

Steven Feuerstein ( just tweeted this:

Next ORCLAPEX NOVA Meetup: July 17th

The next Meetup for the ORCLAPEX NOVA Meetup Group will be this Thursday, July 17th at 7:00PM at Oracle Reston.  (Details:

We're going to try the "Open Mic" format that has been wildly successful at KScope for the past few years.  The rules are quite simple: anyone can demonstrate their APEX-based solution for up to 10 minutes.  No need to reserve a spot or spend too much time planning.  And as always, no slides will be permitted - strictly demo.

view counter