Alert Function

In APEX you will probably use javascript alert function in many cases by saying:

alert ('some message');

The popup box you get looks a bit strange and outdated. As an alternative to this you may use this function call:

function get_alert (p_message,p_id) {$("<div/>", { "html":p_message}).attr({"title":"Error has occurred!"}).dialog({
modal:true,
buttons:{"Go to Error":function(){$(this).dialog("close");
$(p_id).select();}}
}); }


As you can see in this example, you can add additional functions to this alert box (more...)

APEX Jobs

Alle, die eine Beschäftigung mit Oracle APEX suchen, sollten hier reinschauen:

Joel's Blog

Auch einige Stellenangebote aus Deutschland und Schweiz.



Tabular Form, Dynamic Action und Neue Zeile

Einige von euch haben bestimmt schon die ein oder andere jQuery Codezeile in einem Tabular Form verwendet.
Das Ganze funktioniert recht zuverlässig solange der Button "Neue Zeile" nicht verwendet wird. In diesem Beitrag geht es darum, auch auf neue Zeilen reagieren zu können.

Angenommen ich habe in meinem Tabular Form eine Spalte mit einem Textfeld und will den Wert nach dem ändern in eine andere Spalten im Tabular Form übernehmen.
Dazu muss zunächst in der (more...)

Some changes to be aware of, as Oracle Application Express 5 nears…

As the release of Oracle Application Express 5 gets closer, I thought it's worth pointing out some changes that customers should be aware of, and how an upgrade to Oracle Application Express 5 could impact their existing applications.


  1. As Trent Schafer (@trentschafer) noted in his latest blog post, "Reset an Interactive Report (IR)", there have been numerous customer discussions and blog posts which show how to directly use the gReport JavaScript object (more...)

Custom CSV Export in APEX


Sometimes the standard export doesn't fit your requirements. For example you do not want the double apostrophe ".



In those cases take a look at these examples:

http://spendolini.blogspot.de/2006/04/custom-export-to-csv.html
http://www.brainre.org/oracle-apex-csv-file-download-with-iso-encoding-not-utf-8/
https://community.oracle.com/thread/2318795

Let us assume that this is our table:
  CREATE TABLE "MY_TABLE" 
( "ID" NUMBER,
"CAR_NAME" NUMBER,
"CAR_VALUE" NUMBER,
"CAR_KM" NUMBER
) ;
Based on this table I want to create the export.
Next step is to create a (more...)

Tabular Form – Regular Expression Validation

A simple example how to check a tabular form column to be numeric with a max length of 2.

Use a regular expression validation:

APEX 5.0 Fixed Headings for Interactive Reports

When you click on the Attributes of your Interactive Report there's a neath little new features included called "Heading - Fixed to" with as options: None, Region and Page


We've got this request from many customers and it has always been a pain to get it working in every condition with APEX 4.x, but no hacking anymore - it's there now in APEX 5.0.
When you start to scroll the column header will (more...)

APEX 5.0 EA3 – Universal Theme Styles – Gray!

In APEX 5.0 theme 42 is included - this is the Universal Theme. The theme comes with two styles: Blue and Gray.


The UI is so much improved in APEX 5, it's really a game changer. When you look at the details for example from such a style you will see it's using a Less file (Less is a CSS pre-processor) behind the scenes. So it's very easy to make changes to the CSS. (more...)

APEX 5.0 – Run Applications in New Tabs

If you are using Firefox you will probably have an issue with running pages from APEX Builder 5.0 in new Tabs. Now, the links are working differently and normally clicking at button "Save and Run Page" will open a new window. In order to get it opened in a new tab, you will need a plugin Tab Mix Plus. Once you have it, you will need to change the settings there as shown in (more...)

CloudFlare I trusted you :)

For the past months I’ve been using CloudFlare on some projects, mainly web stores build with Magento and some CMS. For the most of them, CloudFlare works really great and I think CloudFlare is a great company. There’s lot of plugins to manage CloudFlare integration with e-commerce solutions and usually it’s pretty straightforward to get the best of it’s services.

Lately I’ve been so busy working with new technologies such as NOSQL databases and reactive (more...)

APEX EA3 released

The third and final early access release of Oracle Application Express (APEX) 5.0 is now released on http://apexea.oracle.com.  Our packaged applications now install much faster; I was able to install p-track (all 166 pages) in 22 seconds.  Our packaged apps now all use our new "universal theme", which is also available when creating custom apps.  The developer interface has been modernized and streamlined.  APEX 5.0 supports model dialogs, theme-rollable theme styles, (more...)

APEX 5.0 EA3 released with Universal Theme

Today Oracle released the latest Early Adopter release of APEX 5.0.


The release is packed with new features, but one of the biggest improvements you can find in the UI.

For me the Universal Theme with Theme Roller, Theme Styles and Template Options is the absolute killer feature of APEX 5.0. I can't better describe Universal Theme as how Oracle is describing it:

Universal Theme is an all-new user interface for your (more...)

Preparing architecture for APEX 5.0 upgrade

I doubted to set the title of this post to "Running APEX 4.2 and 5.0 in the same Oracle instance", but decided not to do that, but that is basically what I will do. Before going into details, I'll share my architecture.

In December 2013 I wrote it was time to update your APEX environment and I gave a quick overview of the architecture we're using. I thought it's time to review that (more...)

DATE – First and Last day of a month

Simple task and simple solution:
-- First day: 
select TRUNC(sysdate,'MON') as first_day from dual
-- Alternative:
select TO_DATE('01.'||TO_CHAR(SYSDATE,'MM.YYYY'),'DD.MM.YYYY') as first_day from dual
-- Last day: 
select LAST_DAY(TRUNC(SYSDATE)) as last_day from dual
Use in APEX as computation for an empty field:

Cookie Applikation

Ich habe in den letzten Tagen an einer Mini-Anwendung gearbeitet: "Cookie Applikation".

Hintergrund:
Die Verwendung von Cookies in APEX ist nicht kompliziert, ist aber ohne die passenden Beispiele etwas mühsam umzusetzen. Deswegen habe ich an einer Beispielanwendung gebaut, die genau die Funktionsweise der Cookie-Nutzung erläutert und LIVE darstellt.

Zusätzlich dazu habe ich den Super Cookie (Canvas Fingerprinting) beispielhaft implementiert.

Also schaut mal rein: https://apex.oracle.com/pls/apex/f?p=155555

Announcement: APEX 5.0 UI Training – May 12th


APEX 5.0 will be released between now and the end of May. People who have already spent some time on the Early Adopter versions know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.

Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way.

The definition of user interface components (more...)

Announcement: APEX 5.0 UI Training – May 12th


APEX 5.0 will be released between now and the end of May. People who have already spent some time on the Early Adopter versions know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.
Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way. 
The definition of user interface (more...)

Riga Dev Day 2015

While waiting at the airport for my plane back to Amsterdam, I have some time to write down my experiences of the last few days in Riga.
After arriving in the hotel, I walked to the old part of town and strolled around. The old part looks very medieval (it is - so no surprises there) with cobblestone streets, old houses and very few cars. Nice!
Then back to hotel, in time for the "official" (more...)

APEX ist überall

Obwohl APEX 5 noch nicht erschienen ist, ist die APEX Community aktiver denn je.

Hiermal eine Überischt der letzten Aktivitäten:

Stuttgart - 22.02.2015
München - 21.02.2015
Colombus (USA) - 15.01. (more...)

JSON for APEX Developers (part 2)

In the previous post we created a service that allowed us to give our data in JSON format.

Now let's focus on consuming that JSON. In this post I want to show how to use JSON data in the client (your browser), in a future post I'll show how to use JSON on the server (in the database).

If you want to play with JSON, open the console of your browser and create some text (more...)