An Introduction To Conditional Control Statements In PL/SQL

Statements which allow you to control the execution flow of the program depending on a condition. In other words the statements in the program are not necessarily executed in a sequence rather one or other group of statements are executed depending on the evaluation of a condition.

In Oracle PL/SQL we have two types of conditional control statements which are

  1. IF statements and
  2. CASE statements

Both these statements can be further divided into different forms. For example IF statements has 3 different forms

  1. IF THEN
  2. IF THEN ELSE
  3. IF THEN ELSEIF

And CASE statement has 2 different forms such as

  1. SIMPLE CASE and
  2. SEARCHED CASE

conditional control statements in pl/sql by manish sharma

I have already done two different tutorials explaining both Simple and Searched Case statements. I highly recommend you to read them.

This is the intro to conditional control statement in Oracle PL/SQL. In the next tutorial you will learn what is IF THEN conditional control statement so don’t forget to read that article. Also kindly share this with your friends and help me reach out to more people. Thanks & have a great day!