New(er) Features of Oracle PL/SQL

Presenter: Steven Feuerstein

Since Oracle Database 12c, a very nice and highly varied set of features have been added to the PL/SQL language. Given the pressure on developers’ time and attention, it can be hard to keep with these new features, especially given how robust PL/SQL has been for years, and how stable are the applications built with it. This presentation makes attendees aware of new possibilities for PL/SQL development, with benefits ranging from runtime performance improvements to improved coding productivity. Steven will cover the following: 18c Qualified expressions for collections and records; PL/Scope now includes SQL statements in its analysis; Whitelisting with the ACCESSIBLE_BY Clause; More PL/SQL-Only Data Types Cross PL/SQL-to-SQL Interface; Optimizing Function Execution in SQL; The UTL_CALL_STACK Package; Privileges/Access Management for Program Units; Static Expressions In Place of Literals; Marking elements for deprecation.