Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing Control Structures
This course will help you acquire certification for the exam 1Z0-149: Oracle Database Program with PL/SQL. It will cover the exam objectives of writing control structures in Oracle PL/SQL.
What you'll learn
This course will help you prepare for your PL/SQL certification by making you proficient with the exam objective of writing control structures in PL/SQL.
In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing Control Structures, you’ll learn various constructs - like IF clauses, CASE statements, and CASE expressions - that Oracle offers for conditional execution.
First, you’ll discover the conditional execution construct of IF ELSIF ELSE clauses.
Next, you’ll take a look at simple CASE statements and searched CASE statements, additional ways to conditionally execute code. Then, you’ll explore their expression counterparts, simple CASE expressions and searched CASE expressions, which can help make code very compact.
Finally, you’ll learn various ways to loop over a set of values using the basic loop, FOR loop and WHILE loops. You’ll discover the characteristics of the loop counter, how to skip loop iterations, and ways to exit the loop.
When you’re finished with this course, you’ll have a good knowledge of the control structures in Oracle PL/SQL which will help you ace that section of the exam - 1Z0-149: Oracle Database Program with PL/SQL.
Table of contents
- Module Overview 2m
- Setup 1m
- IF ELSIF ELSE Statements 5m
- Demo: IF ELSIF ELSE Statements 5m
- Simple CASE Statement 2m
- Demo: Simple CASE Statement 3m
- Searched CASE Statement 2m
- Demo: Searched CASE Statement 2m
- Simple CASE Expression 3m
- Demo: Simple CASE Expression 1m
- Searched CASE Expression 2m
- Demo: Searched CASE Expression 2m
- Summary 2m
About the author
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.