Blogs

September 10, 2023 • 1 min read

Combined APEX chart with ORDERS table

This demo is base on the standard demo tables ORDERS et ORDER_ITEMS. The goal is to produce a chart with a monthly amount stacked with variance and a average monthly amount. ...

September 6, 2023 • 2 min read

FOP Lab - Experimental APEX Project

This application is an experimental project dedicated to developers who need to build sql query generating XML. In addition, the application generates a default xslt FOP template which can be used by a FOP server. Download on Github ...

May 26, 2023 • 2 min read

La cave idéale d’Alexis Goujard pour un budget serré

Je reprends l’article paru dans la revue du vin en octobre 2024. Blanc Méditerranée le terret du domaine Navarre ...

March 31, 2023 • 5 min read

Setup Oracle APEX 22 / DB 21c Express sur Centos chez OVH

Notes et observations Le projet consistait à valider les taches pour obtenir une instance Oracle APEX opérationnelle sur le cloud OVH en SSL avec un nom de domaine et au coût le plus bas. ...

March 27, 2023 • 1 min read

Setting ORDS config path when deploying on Tomcat

From the 22.x version of ORDS, ords.war file must be generated in order to include the configuration directory path. The command is: ords war (ie: ords war ords_new.war) ...

March 19, 2023 • 1 min read

Additional Outputs syntax in Oracle APEX Interactive Grid

When setting Additional Outputs property for a Popup LOV in an Interactive Grid, the syntax COLx:ITEM doesn’t run. A workaround is to set a static id for the target grid column and enter: COLx: instead. ...

January 20, 2023 • 3 min read

Customizing the contextual Help system in an Oracle APEX application

Context and Objectives In an Oracle APEX application, there is possibility to enter Help text at development stage. The help text may be used to provide page level context sensitive help. In almost every component, there is a specific property (Help Text) aimed to receive the text. ...

January 17, 2023 • 1 min read

Improving displaying FullCalendar for Oracle APEX on mobile devices

Even with the last version of Oracle APEX (22.2) which embeds Version 5 of FullCalendar, displaying can be slighty improved to give a better rendering on mobile devices. ...

January 12, 2023 • 1 min read

Using Display Map item with latitude and longitude

Oracle APEX Display Map item allows displaying a map with a point given as a GeoJSON object. What happens if we have only two columns Lat and Long ? ...
Follow me

I work on everything coding and tweet developer memes