Chris Saxon

Chris Saxon 300x300

Chris Saxon

Developer Advocate

Oracle

Biography

Chris Saxon is a Developer Advocate for Oracle Database. His job is to help you get the best out of the Oracle Database and have fun with SQL! To help you with this he blogs at All Things SQL. He also creates videos combining SQL and magic on YouTube at The Magic of SQL. If you have questions about working with Oracle Database technology, please reach out to him. You can do this via Twitter or on Ask TOM.

Papers

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!