Conditional Control Statements in PL/SQL

By Manish Sharma

Introduction of 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

And CASE statement has 2 different forms such as

  1. SIMPLE CASE and

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!

SQL Script and Presentation used

You can DOWNLOAD SQL script and presentation used in the Video and in this article.

NO SQL Script used in Video and in this article

  • Manish Sharma Oracle Rebellion Rider
  • Manish Sharma Oracle certified SQL expert
  • Manish Sharma oracle certified associate
  • Manish Sharma oracle certified professional
  • View Manish Sharma's profile on LinkedIn
  •          View Manish Sharma's profile on LinkedIn