GA ANNOUNCEMENT - SQL Macros now available in Autonomous Data Warehouse
What is a SQL Macro? It is a new and unique way for SQL developers to encapsulate complex processing which can then be reused within SQL statements. Unlike bespoke PL/SQL functions, SQL Macro code is transparent to SQL Optimizer – which brings big benefits since there is no overhead for context switching!
There are two types of SQL Macros:
- TABLE expressions used in a FROM-clause
- SCALAR expressions used in SELECT list, WHERE/HAVING, GROUP BY/ORDER BY clauses
Initially only TABLE macros will be available within Autonomous Data Warehouse. Support for SCALAR macros is coming soon!
For more information see here: