You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GA ANNOUNCEMENT - SQL Macros now available in Autonomous Data Warehouse

edited Sep 3, 2020 3:28PM in Autonomous Database


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: 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!