Author Archives

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.Ano…

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 …

JSON for APEX Developers (part 1)

After my post Generate nested JSON from SQL with ORDS and APEX 5 I got some requests to explain more about REST and JSON, so let me start with JSON. I’ll go more into REST in some future posts.JSON stands for JavaScript Object Notation, it’s …

Setting up Node and Oracle Database driver

Today Oracle introduced the node-oracledb driver, so you can easily connect from node to your Oracle database.Previously I blogged about the Oracle VM you can download so you have your own local Oracle environment. Below are the steps to install the no…

Next ORCLAPEX-BE Meetup – Feb 2nd

Roeland organised a new APEX Meetup in Belgium on February 2nd.This time no specific topic, everybody can get on stage for maximum 5 minutes to show something they did or to ask some feedback or help on a specific problem.If Belgium is to far, no worri…

Setting up your own local Oracle Development environment in less than 15 minutes

The fastest and easiest way to setup your own local Oracle Development environment is by using the “Oracle Technology Network Developer Day” Database Virtual Box Appliance.It contains:Oracle Linux 7Oracle Database 12c (12.1.0.2) EE (CDB/PDB)Oracle…

Generate nested JSON from SQL with ORDS and APEX 5

When creating web applications, at some point you will need to interact with JSON. Either you consume JSON or you need to generate it to be able to use that cool widget you found.A few years ago when I wrote about interacting and customising charts, XM…

Understanding the APEX url – passing variables to items and (interactive) reports

Did you know you can recognise an Oracle APEX application through the url? Here’s the syntax:f?p=appid:pageid:session:request:debug:clearcache:params:paramvalues:printerfriendly&p_trace=YES&cs=…Let me give some examples:https://www.apexrnd.be…

Master Detail – Detail in APEX with FOEX

In the previous post I talked about Master-Detail and that it wasn’t that easy to do Master-Detail-Detail today declaratively in APEX 4.2 (and 5.0).Below is a screenshot of FOEX (a framework build on top of APEX) and a Master-Detail-Detail in ther…

Master Detail (-Detail) in APEX

In the last posts we used following tables to show (Report) and edit (Form) the data:Another way to work with this data is using a Master-Detail report/form.In the master we have our customer info and in the detail the products he’s interested in….