/* Mostly about Oracle APEX, ORDS, PL/SQL and a bit of Linux in between */
Oracle APEX allows you to export applications including all app components as SQL files. This includes application files which binary raw contents are converted into a hexadecimal string representation. This makes it difficult to add, edit or review files from outside an APEX workspace….
Today I would like to show an example to demonstrate how you can identify all dates of occurrences of a single weekday within a period of time in PL/SQL by specifying a weekday. For a project, a form mask in APEX was needed on…
In this blog post I would like to show how to calculate public holidays in Germany within a period of time using a table function in the Oracle database. The calculation of the dates for the public holidays is made on the basis of…