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
what is the use of declare keyword

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

EXIT-WHEN The EXIT-WHEN statement permits a loop to complete conditionally. Whenever the EXIT statement is encountered, the condition in the WHEN clause is computed. When the co

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Sequential Control Dissimilar to the IF and LOOP statements, the GOTO and NULL statements are not important to the PL/SQL programming. The configuration of PL/SQL is such that th

Parameter Modes: You do not require to specify a parameter mode for the input bind arguments (those used, for illustration, in the WHERE clause) as the mode defaults to IN. Th