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
Both these statements can be further divided into different forms. For example IF statements has 3 different forms
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!
You can DOWNLOAD SQL script and presentation used in the Video and in this article.