Oracle if updating then
There is no requirement to surround the expression with parenthesis but most developers use parentheses for clarity.The THEN clause can contain a single or multiple statements, or a nested PL/SQL block.
*/ /* This is the only section of the block that is required.
Syntax for IF-THEN statement is − If the Boolean expression condition evaluates to true, then the block of code inside the if statement will be executed.
If the Boolean expression evaluates to false, then the first set of code after the end of the if statement (after the closing end if) will be executed.
The variable v_other and v_numb will not change unless the condition is true. After executing the example, the variable v_status will be defined as either large or small.
It is the simplest form of the IF control statement, frequently used in decision-making and changing the control flow of the program execution.