#sql-macros

SQL Macros used in Oracle Apex

I've been missing parameterizable views in Oracle for many years.. with SQL macros they have now become possible: (from 19.7) /* teste sql macros */ with parms(p_von_date,p_bis_date) as (select trunc(sysdate) - 14 p_von_date, trun...