Recursion, PL-SQL Programming

Recursion

The Recursion is a powerful method for simplify the design of the algorithms. Principally, the recursion means the self-reference. In the recursive mathematical series, each word is derived by applying the formula to the preceding terms. The Fibonacci series (1, 1, 2, 3, 5, 8, 13, 21, ...), that was first used to model the growth of the rabbit colony, is an example. Each word in the series (after the second) is the sum of the two terms that instantly precede it.

In a recursive description, somewhat is defined in terms of the simpler versions of itself.

Consider the definition of n factorial (n!), that the product of all integers from 1 to n:

n! = n * (n - 1)!

Posted Date: 10/5/2012 5:46:28 AM | Location : United States







Related Discussions:- Recursion, Assignment Help, Ask Question on Recursion, Get Answer, Expert's Help, Recursion Discussions

Write discussion on Recursion
Your posts are moderated
Related Questions
EXIT The EXIT statement forces a loop to done unconditionally. Whenever an EXIT statement is encountered, the loop is done immediately and controls the passes to the next statem

DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

Albeit simple method : These all the truth tables give us our first as albeit simple method for proving a theorem: where check whether it can be written in propositional logic

Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi

JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op

Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no

Renaming Columns - SQL SQL has no direct counterpart of RENAME. To derive the table on the right in Figure 4.4 from the table on the left, Tutorial D has IS_CALLED RENAME ( St

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Indeterminacy in SQL Some SQL expressions are actually not function invocations at all in the mathematical sense, being indeterminate-invocations operating on identical input

CHECK Constraints in SQL A CHECK constraint is a table constraint defined using the key word CHECK, as already illustrated in several examples in this chapter. In particular,