While loop Oracle

While loop is an another looping structure. It is also called conditional loop. It evaluates the condition before each iteration executes. While loop is effective when how number of iterations are not known prior to the execution.