2. Write a script that uses an anonymous block of PL/SQL code to declare two variables...

 

Transcribed Image Text:

2. Write a script that uses an anonymous block of PL/SQL code to declare two variables to store (1) the count of all of the products in the Products table and (2) the average list price for those products. If the product count is greater than or equal to 10, the anonymous PL/SQL block should display a result set that displays the values of both variables. Otherwise, the program should display a result set that displays a message that says, "The number of products is less than 10". 2. Write a script that uses an anonymous block of PL/SQL code to declare two variables to store (1) the count of all of the products in the Products table and (2) the average list price for those products. If the product count is greater than or equal to 10, the anonymous PL/SQL block should display a result set that displays the values of both variables. Otherwise, the program should display a result set that displays a message that says, "The number of products is less than 10".