Oracle Database 19c PL/SQL

PL/SQL is the companion programming language to Oracle Database. Having a modern programming language that integrates with the database itself makes the Oracle Database platform scalable and extensible for more applications. In this course, Instructor reviews the major features of Oracle PL/SQL under Oracle Database 19c.

Instructor covers key aspects of this procedural language, including looping, conditional statements, and exception handling when something goes wrong. He shows how to more effectively use the built-in procedures of PL/SQL, as well as write your own. Instructor highlights ways to simplify coding of loop iteration in PL/SQL programs.

He also covers the PL/SQL security model and demonstrates how to run SQL queries and DDL statements from within PL/SQL.