Answers for "if else in where clause oracle sql"

6

oracle else if

IF condition1 THEN
   {...statements to execute when condition1 is TRUE...}

ELSIF condition2 THEN
   {...statements to execute when condition1 is FALSE and condition2 is TRUE...}

ELSE
   {...statements to execute when both condition1 and condition2 are FALSE...}

END IF;
Posted by: Guest on May-08-2020

Browse Popular Code Answers by Language