1/*in plsql you can do the switch construct by using the case construct that
2you usually use in queries but with the difference that you should specify
3"END CASE" at the end*/
4CASE some_variable
5 when 'value_1' then
6 --some code
7 dbms_output.put_line('lalala');
8 when 'value_2' then
9 --some code
10 dbms_output.put_line('dadada');
11 else
12 --some code
13 dbms_output.put_line('dududu');
14END CASE;
15