---
title: "#sql-macros articles | Hashnode"
description: "Explore 3 articles tagged #sql-macros on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/sql-macros"
---

Tag

# #sql-macros

3 posts · 0 followers

[Sergey Shishkin](https://hashnode.com/@Serj-Aleks) · [May 29, 2025](https://hashnode.com/posts/read-macros/6838188ce4534099a88bc077)

### [Read-Macros](https://serj-aleks.hashnode.dev/read-macros?utm_source=hashnode&utm_medium=feed)

В документации целых три классификатора, которые можно позиционировать как группы функций базы данных, собственно, база данных, система запросов типа SQL-Prolog (Pilog) и предикаты, а если считать, что реализованная система управления базой данных, с...

2 min read · [serj-aleks.hashnode.dev](https://serj-aleks.hashnode.dev/read-macros?utm_source=hashnode&utm_medium=feed)

[Phil Grinham](https://hashnode.com/@PhilGrinham) · [Dec 1, 2023](https://hashnode.com/posts/sql-macros-pipelined-function-killers/6569685945975061a50ac158)

### [SQL Macros - Pipelined Function killers?](https://philgrinham.hashnode.dev/sql-macros-pipelined-function-killers?utm_source=hashnode&utm_medium=feed)

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 ...

4 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/sql-macros-pipelined-function-killers?utm_source=hashnode&utm_medium=feed)

[Tom Lieber](https://hashnode.com/@Yaitcon) · [Feb 19, 2023](https://hashnode.com/posts/sql-macros-used-in-oracle-apex/63f22b37307c837103810230)

### [SQL Macros used in Oracle Apex](https://yaitcon.hashnode.dev/sql-macros-used-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

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...

3 min read · [yaitcon.hashnode.dev](https://yaitcon.hashnode.dev/sql-macros-used-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/sql-macros-used-in-oracle-apex/63f22b37307c837103810230)
