How to use If else condition in Oracle

Here is sample to code to use if , else and else if condition in  oracle. this is very simple to use, Please let me know if you face any problem.

Here keywords are in capital letter and variable and constant are in small letters.

 

       IF number_1 > number_2 THEN
          v_result :='number 1 is greater than number 2'
       ELSIF number_2 > number_3 THEN
         v_result :='number 2 is greater than number 3'  
       END IF;