Loading Course Schedule...
PT27126
Training 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.
Course 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