Create reusable SQL expressions with SQL macros
Event: Connect 2021
Stream: APEX, Development/Middleware, Integrations, Security, Tools
A common criticism of SQL is it lacks composability – the ability to define small units you can combine into larger functions. Oracle Database addresses this with the introduction of SQL macros. These return SQL expressions, enabling you to define reusable components. Using SQL macros you can SQL templates which you can pass tables, columns, and other values to at runtime. This enables you to build a library of functions to solve common problems, such as finding consecutive rows or the top-N rows per group. Join this session to learn what SQL macros are, how to define them, and see examples of these in action. This presentation is for developers and DBAs who want to write better SQL.
Oracle Database 21c for Developers
Event: Connect 2021
Stream: APEX, Development/Middleware, Integrations, Security, Tools
Oracle Database 21c brings a host of SQL and PL/SQL enhancements to help you build better, faster, more secure data-driven applications. This session gives an overview of the top new features for developers, including: * SQL macros which you can use to make reusable SQL fragments * Window clause enhancements for analytic functions * Improved loop controls and array initialization methods in PL/SQL If you're a developer or DBA who regularly writes SQL or PL/SQL and wants to keep up to date this session is for you!