switch plsql
/*in plsql you can do the switch construct by using the case construct that
you usually use in queries but with the difference that you should specify
"END CASE" at the end*/
CASE some_variable
when 'value_1' then
--some code
dbms_output.put_line('lalala');
when 'value_2' then
--some code
dbms_output.put_line('dadada');
else
--some code
dbms_output.put_line('dududu');
END CASE;