Introduction to Oracle PL/SQL Programming

PT27126
Summary
The course provides a comprehensive introduction to PL/SQL, Oracle’s procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment. This course can be taught for any Oracle version.
Prerequisites
Oracle SQL or equivalent experience
Duration
3 Days/Lecture & Lab
Audience
Programmers and Database Administrators responsible for the development or maintenance of application systems which access an Oracle database.
Topics
  • Overview of PL/SQL
  • Variables and Constants
  • PL/SQL Executable Statements
  • Embedding SQL Within PL/SQL
  • Explicit Cursors
  • Handling Exceptions
  • PL/SQL Stored Programs
  • Oracle 18c New Features

Related Scheduled Courses