Database-loop statement: Case When/then else end;

Case Loop statement:

1: Grammar

The basic form of a case statement is:

Case Selector

When Expression1 then RESULT1
When Expression2 then RESULT2
When Expressionn then RESULTN
[ELSE resultn+1]
END;

2: Example

Declare
V_annum char (1): =upper (' &nom ');
V_appression VARCHAR2 (30);
Begin
V_appression: =
Case V_annum
When ' A ' then ' excellent '
When the ' B ' then ' Very good '
When ' C ' then ' good '
When ' D ' and ' bad '
Else ' No such annum '
End
Dbms_output.put_line (' You have entered ' | | v_annum| | '; ' | | V_appression);
End

Database-loop statement: Case When/then else end;