Create a visitors application that prompts the user for the number of visitors each day for the past 5 days and then displays the average number of visitors per day. (use & to accept new value) Use PL/SQL Array (NUMBER type basic composite array type ) and array has to have 5 members only. The application output should look like same as following: Test: If you receive below numbers from user then your average should be 234. Display avarage on screen. 1: 150 2: 220 3: 180 4: 300 5: 320 The average number of visitors is: 234 Hint : Once you create Array DECLARE TYPE my_array_type IS TABLE OF number INDEX BY PLS_INTEGER; v_n_array my_array_type; Then in the BEGIN and END block accept new value for each array members. DO NOT Use LOOP to accept new & as it is not design to get new value via loop.. Instead use separate 5 different &substitution value to get each values from user input BEGIN v_n_array(1):= &n1 v_n_array(2):=&n2 ……………. ………… Collect all v_n_array members (5 different numbers) and then do calculations like finding average. v_avg := ………… Then Display them DBMS_OUTPUT.PUT_LINE (‘The average number of visitors is: ‘ || v_avg ) END;
Create a visitors application that prompts the user for the number of visitors each day for the past 5 days and then displays the average number of visitors per day. (use & to accept new value)
Use PL/SQL Array (NUMBER type basic composite array type ) and array has to have 5 members only. The application output should look like same as following:
Test: If you receive below numbers from user then your average should be 234. Display avarage on screen.
1: 150
2: 220
3: 180
4: 300
5: 320
The average number of visitors is: 234
Hint :
Once you create Array
DECLARE
TYPE my_array_type IS TABLE OF number INDEX BY PLS_INTEGER;
v_n_array my_array_type;
Then in the BEGIN and END block accept new value for each array members. DO NOT Use LOOP to accept new & as it is not design to get new value via loop.. Instead use separate 5 different &substitution value to get each values from user input
BEGIN
v_n_array(1):= &n1
v_n_array(2):=&n2
…………….
…………
Collect all v_n_array members (5 different numbers) and then do calculations like finding average.
v_avg := …………
Then Display them
DBMS_OUTPUT.PUT_LINE (‘The average number of visitors is: ‘ || v_avg )
END;
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)