Applied MathBusiness ManagementBusiness Management/AdministrationComputer Information SystemsComputer ScienceComputing & Information TechnologyCybersecurityMath

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, Bob Bryla reviews the major features of Oracle PL/SQL under Oracle Database 19c. Bob 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. Bob highlights ways to simplify coding of loop iteration in PL/SQL programs. Plus, he covers the PL/SQL security model and demonstrates how to run SQL queries and DDL statements from within PL/SQL.

Learn More