Oracle WHILE Loop
The WHILE loop is executed untill the condition of end is fulfilled. Simple example:
This loop will be executed untill current value of variable v_counter will be less than ten.
The most important thing is, that our loop starts with '0' value, so first line of results is 'Current iteration of loop is 0'.