---
title: "Discussion on \"SQL Macros used in Oracle Apex\" | Hashnode"
description: "Discussion on \"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)\n/* teste sql macros */\n\nwith parms(p_von_date,p_bis_date) as \n     (select trunc(sysdate) - 14 p_von_date,\n             trun..."
url: "https://hashnode.com/posts/sql-macros-used-in-oracle-apex/63f22b37307c837103810230"
---

[Feed](https://hashnode.com/feed) /

Discussion

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

Feb 19, 2023 · 3 min read · yaitcon.hashnode.dev  
Updated Jul 25, 2023  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#sql-macros](https://hashnode.com/tag/sql-macros)
-   [#orclapex](https://hashnode.com/tag/orclapex)

## Written by

[Tom Lieber](https://hashnode.com/@Yaitcon)

@Yaitcon · Vienna, Austria

  
[View profile](https://hashnode.com/@Yaitcon)

Yet another IT Consultant

Databaseguy, Oracle Apex Lover

## Responses 1

Markdown supported · ⌘↵ to post

[Tom Lieber](https://hashnode.com/@Yaitcon)

[Feb 19, 2023](https://hashnode.com/posts/sql-macros-used-in-oracle-apex/63f22b37307c837103810230/comment/63f26e759a615a95ce2ed8c0)

[asktom.oracle.com/pls/apex/f](https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9546107300346404287)
