Oracle Pl Sql If Then Else Statement Elsif Nested If
Types of Decision Making Statements: Oracle provides the following types of decision making statements. IF-THEN IF-THEN-ELSE IF-THEN-ELSIF NESTED-IF CASE SEARCHED CASE In this tutorial, you will learn- Introduction to Decision Making Statements IF-THEN Statement IF-THEN-ELSE Statement IF-THEN-ELSIF Statement NESTED-IF Statement IF-THEN Statement The IF-THEN statement is mainly used to execute a particular section of codes only when the condition is satisfied. The condition should yield Boolean (True/False). It is a basic conditional statement which will allow the ORACLE to execute/skip a particular piece of code based on the pre-defined conditions....