Session Abstract
SQL macros were introduced in Oracle database version 21c. You know, that version really nobody is actually using. They backported *some* of the functionality to 19c, so you may have table expression macros available in your daily work already.
Although the (on prem) release of 23ai has been postponed a couple of times it is getting closer and will at some point in the near future be generally available, and with it the full power of SQL macros will be at our fingertips. So, it’s high time to really get to know them.
SQL macros allow us to define bits and pieces of code (expressions/table expressions) that are placed into the sql statement that references the macro.
Sounds great.
So, let’s have a look at what types of SQL macros there are, what they could be used for and the syntax of creating and using SQL macros. We will also have a look at how they compare to other options we have to centralize definition of expressions and to make SQL statements more dynamic.
Do we now make everything a SQL macro, or are there reasons not to? What are the limitations of SQL macros?
Join this session to get those questions answered.