The native PL/SQL insert statement in the first example actually generates a recursive SQL statement--'insert into mytestvalues(:1)'--and binds the values on each iteration.

Recursive SQL can be very elegant and efficient. However, because of the difficulty developers can have understanding recursion, it is sometimes thought of as “too inefficient to use frequently.” But, ...

demonstrate you how to use recursion in T-SQL, using one of the classic examples of recursion: the factorial calculation. A factorial is the multiple of any number by all the lesser numbers down ...

Hey All,Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table called ...