Phil Grinhamphilgrinham.hashnode.dev·Dec 1, 2023SQL Macros - Pipelined Function killers?Introduced in Oracle 21c and back-ported to Oracle 19c, SQL Macros have been an excellent addition to the developer's toolset. These "parameterized views" come in two different flavours, Table Expressions and Scalar Expressions, with the latter only ...2 likes·473 readspipelined functions
Tom Lieberyaitcon.hashnode.dev·Feb 19, 2023SQL Macros used in Oracle ApexI'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...2 likes·370 readsAutonomouse CarLogBookSQL
