The information covered in this series helps you get started on the Oracle Certified Database Administrator and/or
Certified Application Developer tracks. Another important goal of this series is to enable you to
- create advanced SQL queries,
- write beginning to intermediate PL/SQL blocks, and
- familiarize you with Oracle's unique SQL extensions.
PL/SQL is an integral part of the Oracle database engine.
This course will introduce you to PL/SQL and explain how you can build PL/SQL programming structures.
PL stands for Procedural Language.
This language offers procedural techniques to build your SQL (Structured Query Language) commands.
You can use this language to construct procedures, triggers, functions, packages, and more.
After completing the course, you will be able to:
Describe the basic structure of a PL/SQL block
Create a nested PL/SQL block
Describe the different PL/SQL and non-PL/SQL variables
Identify the scope of variables when using nested blocks
Apply best practices for naming conventions and commenting your code
Gain an overview of the different PL/SQL datatypes, including composite datatypes such as PL/SQL RECORD and TABLE
Place identifiers and use literals and operators within a PL/SQL block
Build logic by using PL/SQL control structures, including loops, labels, and the
Use explicit cursors to process multiple records
Raise implicit and explicit exceptions
In this course, you will learn and practice PL/SQL skills with MouseOvers and Slide Shows.
Programming in PL/SQL
is the second of three courses in the Introduction to Oracle Certification Series
In the next lesson, the Oracle PL/SQL
Course Requirements will be discussed.