Question: Oracle SQL Write a script that performs the following: 1) Creates the Fibonacci function (refer to a mathematical resource) 2) Creates an anonymous block that

Oracle SQL

Write a script that performs the following:

1) Creates the "Fibonacci" function (refer to a mathematical resource)

2) Creates an anonymous block that allows the user to input an integer value, that will be used as the upper bound of a FOR Loop

3) Calls the "Fibonacci" function for each iteration of the FOR Loop and displays the value of the iteration variable and the corresponding "Fibonacci" number.

Notes:

Substitution variables are described in Chapter 2 and in the SQLPlus Reference section,http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm#CACIFHGB (Links to an external site.)Links to an external site.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!