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;
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
