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!
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.