28 Jun
Recursion vs Iteration
When writing code to do repetitive tasks, the two primary approaches are iteration and recursion. Generally you can use either one interchangeably, but potentially with different performance and complexity.
A recursive function calls itself (possibly more than once), with different parameters, and defines an exit clause that is guaranteed to be reached.
CREATE OR REPLACE FUNCTION