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
Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP

Using Pragma RESTRICT_REFERENCES: The function called from the SQL statements should obey certain rules meant to control the side effects. To check for violation of the rules,

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Example of Table Literal - SQL Example: A Table Literal (correct version) VALUES ('S1', 'C1', 'Anne'), ('S1', 'C2', 'Anne'), ('S2', 'C1', 'Boris'), ('S3', 'C3'

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

Semidifference and NOT - SQL In this section first describe the relational difference operator, named MINUS. Example here shows SQL's closest counterpart of that operator.

Use Bulk Binds If SQL statements execute inside a loop using the collection elements as bind variables, context switching between the PL/SQL & SQL engines can slow down the ex

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state