switch plsql
Solutions on MaxInterview for switch plsql by the best coders in the world
{{#items}}
{{text}}
{{/items}} 
{{ctaText}}
we are a community of more than 2 million smartest coders
{{#items}} {{/items}}
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
showing results for - "switch plsql"
Niklas
07 Jan 2021
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;
15similar questions
pl sql if elseswitch case sql serverpl 2fsql case when multiple valuesswitch case sql columnpl sql modify column nmeprint boolean in plsqlcase when postgresfor cursor plsqlfunction pl sql with selectoracle casetsql case whenpl sql cursorpl sql casecase when switch in sqlpls sql updatepgsql sum switch caset sql casemysql switch casepl sql implicit cursor your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful