Becoming a certified PL/SQL developer requires knowledge of variables. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 – Declaring PL/SQL Variables, you’ll learn everything you need to know about declaring and using PL/SLQ variables. First, you’ll explore what variables are and how to declare them. Next, you’ll discover how to recognize valid and invalid variable identifiers. Finally, you’ll see how to use different types of variables. When you’re finished with this course, you’ll have the skills and knowledge of PL/SQL variables needed to answer the exam questions related to this topic.
Author Name: Esteban Herrera
Author Description:
Esteban Herrera has more than fifteen years of experience in the software development industry. He has worked in many roles and projects, but mostly architecting and developing enterprise systems with Java and Javascript. Nowadays, he spends all of his time learning new things, writing articles, teaching programming, and enjoying his kids.

Table of Contents

• Course Overview
  1min
• Introducing Variables in PL/SQL
  15mins
• Declaring Variables
  15mins
• Recognizing Valid Variable Identifiers
  14mins
• Working with Data Types and %TYPE and %ROWTYPE Attributes
  25mins