Posts

Showing posts from 2025

Getting up to speed with Oracle Application Express (APEX)

Image
Want to start developing web applications with Oracle Application Express (APEX)? Make sure you don't reinvent the wheel and adapt good practises from industry experts right from the start. Here are some tips for beginners: 1. If you don't already have Oracle APEX installed, don't install it yourself, but get a free workspace within minutes on apex.oracle.com  to be used for demo purposes. To learn about Oracle APEX in the Oracle Cloud, you can use the always free tier on cloud.oracle.com/free with two databases up to 20 GB database storage each without any cost. For production purposes, we recommend that you pay 115 €/month (as of 20-JAN-2025) for the Oracle APEX Service on the Oracle Cloud. 2. Start making your first apps using one of the Oracle APEX tutorials: Hyand (German):  apex.hyand.com/development  (includes good practises!) Oracle (English):  apex.oracle.com/en/learn/tutorials  ( here is a good overview of these) 3.  Take note of some...

My favorite new features in APEX 24.2 at a glance

Image
Oracle APEX 24.2 is out! Here are some of the major features in APEX 24.2 that I think are a great productivity booster for APEX developers. JSON Sources With storing JSON in a CLOB or BLOB column, you get some flexibility in your data model. Before 24.2, you couldn't let your APEX chart, form or report interact with the JSON structure without custom coding. With 24.2, this is now possible using JSON Sources. There is no need anymore to deal with JSON yourself using SQL, just let APEX do the heavy lifting. For those of you using 23ai of the Oracle Database, it works even with JSON Collection Tables and Duality Views! APEX Workflow enhancements Major features here include the possibility to call a workflow from with another workflow. This will let you re-use smaller workflow definitions. Also, a workflow administrator can now resume a workflow at any given activity in case of an unforeseen situation. Great must have features! For those of you that need to be BPMN-compliant, you migh...