PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma

Key Takeaways

what's up internet welcome back once again I'm Manish from Rebellion rider.com so the previous tutorial was all about simple if then statement in Oracle PL zq there we learn that simple if then statement enables us to specify the sequence of statements to be executed only if the condition is evaluated to be true in case this condition is evaluated to be false then no special action is to be taken except to proceed with the execution of the program to overcome this drawback in Oracle PL SQL we have if then else statement widely pronounced as if else statement with if then else in PL SQL we have two groups of executable statements one which gets executed if the condition is evaluated to be true and another group gets executed if the condition is evaluated to be false once the if then else construct gets completed the next statement right after if then else block is executed let's take a quick look at the syntax of if then else statement and here is the syntax as you can see if then else construct starts with the keyword if and ends with the reserve phrase and if which is very similar to the simple if then statement which we saw in the previous tutoria anyways followed by if keyword we have to specify a valid condition which will get evaluated if this condition is evaluated to be true then control is pass to the statement one and if this condition is evaluated to be false then control will jump over statement two once the construct is completed then statement three is executed hope this made the concept of if then else clear to you all if you still have any question or suggestion then feel free to leave a comment down below so now it's time to do some examples because they are the best way to understand the concept I think you all will agree with me on this so let's jump over SQL Developer and do some examples so we will start with a very simple example here in this example we will take a numeric input from the user and we'll check whether a user has entered an even number or an odd number using IF then else's statement this is going to be a very easy example for in the Declaration section of this block I have declared a variable Vore num with the data type number and using substitution operator I am taking values from the user next in the execution section of the block we have our if then else construct where we are checking whether the number entered by the user is even or odd for this test I have used mod function of Oracle Library as our if condition which will divide the first parameter by the second parameter and return return the remainder or say modulus if this modulus is zero then number will be even otherwise number will will be odd thus if the modulus comes as zero then control will jump over first dbms output statement and will print the given string but if modulus is not zero then control will jump over second dbms _ output statement and display its string once this is complete then control will come out from the if then else construct and will print the third dbms undor output statement so let's execute this PL SQL block and check the result my first input will be 20 and here is our result let's execute once again and this time let's take 25 as an input number 25 is odd and that is our result you can visit my blog and copy this example and try it by yourself link is in the description I'm always willing to learn new things from you guys so if you have any better example for if than else's statement in PL SQL demonstration then please feel free to comment or you can tweet me the screenshot of your code at Rebellion WR up with this I'll take your leave thanks for giving your time hope you enjoyed watching please give this video a thumbs up and share it on your social also don't forget to subscribe we'll see you soon with another tutorial till then take care this is Manish from Rebellion Rider