In Oracle, a recursive call is a call, for example, that must be completed before the user's SQL can be completed.
Say you wanted to order a pizza for delivery. You make one call, place your order, and wait for your pizza.
You do NOT call the kitchen staff directly and tell them how to make your pizza , call the cashier to give him your credit card number, call the delivery man and tell him to pick up your pizza and bring it to your house.
Nope, you make one call, not three. The person you place your order with makes those "recursive" calls to the kitchen and delivery staff to make sure your order is complete.
The kitchen staff may make additional "recursive" calls ("Where are the mushrooms?") as may the delivery man ("Where is that street located?").
You don't care about these details, you just want your pizza.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11517198/viewspace-544626/，如需转载，请注明出处，否则将追究法律责任。