Oracle APEX Cookbook [Second Edition] – Book Review

Recently the second edition of the APEX Cookbook has seen the light. As I haven’t read the first edition - I know, shame on me - I can’t exactly point out what the differences are, but that doesn’t really matter anyway. I guess no one will buy both versions anyway…

The book follows a different approach than most of the tech books I read (and wrote): Every issue is attacked with a recipe, existing of (more...)

Why do I attend Kscope?

Kscope14 will be my 6th Kscope event. After New Orleans, Monterey, Washington, Long Beach and New Orleans again (yes, I missed San Antonio), this year Seattle will be the place to be at the end of June.

So why do I spent quite a lot of time and money to visit this event? That's because of two reasons: the content and the fellow attendees. Without any doubt the content of Kscope is best you can (more...)

The evolution of APEX Evangelists

Every year we at APEX Evangelists come together to discuss the past and the future of the company. In the past 7 years a lot has changed; the APEX market changed, the community changed, we personally changed, etc ...
We really like APEX, we are all passionate about it, we love to have technical discussions with each other and come together to share our thoughts, but we also like our independence and make our own trade-offs (more...)

Where’s Wally? Or upcoming conferences for the first half of 2014 ….

Conference season has started as usual with RMOUG - where I've never been and still would love to go once. The conferences for the first half of the year where I will be presenting are listed below.

February 13, ODTUG online webinar
Together with Mia Urman I will be presenting "Running Oracle Forms from an APEX Application". About five years ago I wrote an article and presented about how to integrate Forms and (more...)

How to reset an APEX process

While I was setting up a demo the other day, I ran into the following issue: My main start page contains a list of customers and that list is created by a call to a (remote) web service. Due to the nature of this service, it takes a few seconds to get a result back - not very slow but slow enough to annoy me. So I looked at ways of caching the web service (more...)

Oracle APEX Reporting Tips & Tricks – Book Review

Just after my not-so-positive previous book review, another author dared to ask me for my review. I asked him whether he was sure, and he - confidently - answered positive. This book, written by George Bara from Romania, is called "Oracle APEX Reporting Tips & Tricks", so - (more...)

APEX 4.2 Reporting – Book Review


Recently I was asked by someone from Packt Publishing to review the new book "Oracle APEX 4.2 Reporting" - in exchange for a free e-copy.

When I saw the table of contents, I already thought: "This is covering a lot...". And that turns out to (more...)

Creating RESTful API’s with the APEX Listener

In REST you model the resources, not the actions. So you define a GET /apex/oow13/hr/employees instead of a GET /apex/oow13/GetAllEmployees. With REST you have six methods (with the most common associated database actions: GET (select), HEAD (select), OPTIONS (to get a list of methods supported by the resource), PUT (merge (more...)

Mobile Development with APEX 5.0

In APEX 5.0 a Tablet User Interface will be introduced. The idea is not that you will end up with three user interfaces (Desktop, Tablet and Mobile), but use te Tablet UI for desktop usage as well. You might even want to use the Tablet UI - as an (more...)

Oracle Database 12c Real Application Security and APEX

Oracle Real Application Security (RAS) applies security policies at the database layer. So those policies are applied to the data and is not relying on the security built in into an application (like VPD). Security is applied to direct connections. Policies are stored in an "Identity and Policy Store".

OOW 2103 : Get your own Database Instance in the Cloud

Today the "Database as a Service" has been announced. Not to confuse with the "Database Platform as a Service" that was announced last year and is available since early this year. With the "platform" service, you get one schema within a database. With the "database" service, (more...)

OOW 2013 : The new Oracle In-Memory Database

Today the new In-Memory technique for the Oracle database has been introduced. This is not something like TimesTen(+) or so, but a new way of querying data. The concept is like this: All tables that are marked for keeping data in-memory, will be "stored" using both row and column format. (more...)

My OOW 2013 Expectations

Redwood Shores, Thursday September 19. 5:30 AM. 
5:30 AM? So I must be in the "wrong" timezone.... Just like most European based Oracle ACE Directors in this hotel I woke up early. Not as early as some others - I noticed tweets from around 2:30 - but nevertheless early.

Running an APEX app native on an iPhone – revisited

Almost two years ago I wrote two blogposts about how to run an APEX application as native as possible on an iPhone (see the demo and the details). But that was so long ago, using Phonegap 1.3.0 and APEX 3-something.
Nowadays we have APEX 4.2 with (more...)

Get your abstracts in for the best conference of 2014 !

We're just in the second half of the 2013 and now we're already talking about "The best conference of 2014"? 
Yep! And this conference will be held on Jun 22-26 in Seattle. So I am talking about ODTUG Kscope 14. What else could it be .... And the best conference (more...)

APEXposed 2013, Sep 10 and 11 in Montreal

While KScope seems only a few weeks ago, ODTUG already announced a new great APEX event!
APEXPosed 2013 will be held on September 10 and 11 in Montreal. The agenda looks great, with a nice mix from local and international speakers. The APEX Development Team will be represented by both (more...)

Two articles in one week…

Last week I presented at the OUG Scotland conference. To my surprise, I received the latest, 50th edition (!), of Oracle Scene - the publication of the UK OUG during registration. And, less to my surprise, there was an article in there written by yours truly: "Building Mobile (more...)

APEX Conditions and Performance

Thanks to a tweet of Scott Wesley (@swesley_perth), I stumbled upon this blog post by Tony Andrews. In that blog Tony lists a few examples of APEX Conditions and concludes that the declarative approach must be the best way of doing it. Although his assumptions and conclusions makes a lot (more...)

Using LDAP for Authentication and Authorization within APEX

One of my current customers would like to use their LDAP (Microsoft Active Directory) server for authentication and authorization of APEX applications. Of course we tried to set up a standard LDAP Authenication that's available within APEX. But we couldn't get that to work. Maybe it has to do with (more...)

How attending #Kscope13 can change your life …

Wow. Doesn't that sound dramatic? It sure does. But in a weird way it also might come true - as I have experienced in the past.
The first Kscope conference I attended was five years ago. And purely by coincidence that was in New Orleans as well! That first year I met all the (more...)