Oracle--case, while, loop, for

1. Case Expressions in Oracle

(case condition when expression 1 then result 1 when expression 2 then result 2 [else result n]end) as Alias

2. Simple loop Loops

Loop to execute the statement;        Exit when< Condition >/* Condition satisfied, exit Loop statement */end Loop; actual example loop v_tmp: = v_tmp + 1; Exit when v_tmp = 10;end;

3. While loop

While < Boolean expression > loop statement to execute; end loop;            The actual example begin v_tmp: = 1;             While v_tmp <=10 loop v_tmp: =v_tmp+1; End Loop;end;

4. Digital Cycle

For loop variable in "reverse" lower limit: Upper loop to execute the statement; end Loop; Note: The loop variable is automatically added 1 per loop, and the loop variable is automatically reduced by 1 using the keyword reverse. The actual example of begin for v_tmp in 1..10 Loop--its own operating section end Loop;end;

Oracle--case, while, loop, for