Title: Learning Objectives
Course: Introduction to Oracle SQL and PL/SQL (10610) > Section: Competency Modules

After completing this chapter, you should be able to:

- Describe programming fundamentals
- Define the PL/SQL block
- Define and declare variables
- Initialize and manage variable values
- Recognize the NOT NULL and CONSTANT variable options
- Perform calculations with variables
- Use SQL single-row functions in PL/SQL statements
- Apply decision structures: IF-THEN and CASE
- Apply looping actions: basic, FOR and WHILE
- Use CONTINUE statements
- Use Nested statements