If...then...elsif in Oracle

If...then...elsif implementation of multi-branch judgment statements

Its syntax is as follows:

If <condition_expression1> Then

Plsql_sentence_1;

Elseif<condition_expression2> Then

plsql_sentence_2;

...

Else

Plsql_sentence_n;

End If;

There is no condition behind the last else, which is more important.

Specific examples:

DeclareV_monthint:=2;begin  ifV_month>=1  andV_month<=3  ThenDbms_output.put_line ('Spring'); elsif V_month>=4  andV_month<=6  ThenDbms_output.put_line ('Summer') ; elsif V_month>=7  andV_month<=9  ThenDbms_output.put_line ('Autumn') ; elsif V_month>=Ten  andV_month<= A  ThenDbms_output.put_line ('Winter') ; ElseDbms_output.put_line ('the season you entered does not exist! ') ; End if;End;

The output is:

Spring

-----------------------------------but make Dragon City fly will be in, do not teach horses degree Yinshan

If...then...elsif in Oracle