/* Mostly about Oracle APEX, ORDS, PL/SQL and a bit of Linux in between */
When working with Oracle APEX, the syntax of generating links via APEX_UTIL.prepare_url is dependent on the app session and whether Friendly URLs are enabled or not. Based on the session context, the function will generate absolute or relative URLs. These differences become apparent, for…
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…