The information covered in this series helps you get started on the Oracle8 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 GOTO statement
-
Use explicit cursors to process multiple records
-
Raise implicit and explicit exceptions
In this course, you will learn and practice PL/SQL skills with many kinds of applets,
including 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 