Chris Saxon

chrissaxon-250-250

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 has created free SQL classes on Oracle Dev Gym, blogs at All Things SQL, and creates videos combining SQL and magic on The Magic of SQL YouTube channel. 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

Oracle Database 21c for Developers

Event: Connect 2022
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!

Crimes Against SQL

Event: Connect 2022
Stream: APEX, Development/Middleware, Integrations, Security, Tools

Oracle Autonomous Database includes many tools to self-optimize slow-running SQL statements. But no matter how good the database gets, there are many SQL anti-patterns that will lead to slow applications. This session covers three of the worst offenders: concatenating user input into statements, placing SQL inside loops, and accessing the same table many times in one query. Join this talk to learn why these lead to slow data access and how using PL/SQL helps you avoid these problems to build better, faster, more secure data-driven applications.