In this chapter you learned about PL/SQL concepts. You explored PL/SQL block structure, substitution variables, and the DBMS_OUTPUT.PUT_LINE statement. Here are some exercises that will help you test the depth of your understanding.
|1)||In order to calculate the area of a circle, the circle’s radius must be squared and then multiplied by π. Write a program that calculates the area of a circle. The value for the radius should by provided with the help of a substitution variable. Use 3.14 for the value of π. Once the area of the circle is calculated, display it on the screen.|
|2)||Rewrite the script ch02_2b.sql, version 2.0. In the output produced by the script, extra spaces appear after the day of the week. The new script ...|