Question $3$

$3\mathrm{.}1$ Create a PL$\backslash$SQL anonymous block displays book details: the book's name and category, the

publisher's name and publication date, and the retail price of the book. The book should fall under

the category's name beginning with the letter $\text{'}C\text{'}$ and ending with the letter $\text{'}G\text{'}.$ Additionally, the

book must cost less than R$20\mathrm{.}00.$ Make use of $\%$TYPE attributes.

Your output should resemble the output below:

Book Details

Title: Cooking With Mushrooms

Category: Cooking

Published by: Reading Materials Inc.

Published on: $28$ February $2000$

Price: R$19\mathrm{.}95$

PL$/$SQL procedure successfully completed. $1\mathrm{.}1$ Ireates PL$/$Sol anonymou block that addo a new author using the defaili betow:

Your output should resemble the output below:

atithor$($s$)$ adifed.

PL$/$SQL procedure sucgessfully completed.Question $2$

$2\mathrm{.}1$ Write a PL$/$SQL anonymous block to calculate the area, diameter and the circumference of a

circle. The program block should prompt the user to enter the radius at run time.

Formulae:

$\frac{?}{P}=$I

Area $=$ radius ${?}^2$

Diameter $=2^{**}{}^{**}$ radius

Circumference $={}^{**}$ radius ${?}^2$

Enter value for radius: $5$

The area of the circle is: $79cm$ squared.

The diameter of the circle is: $10cm$

The circumference of the circle is: $31cm$

PL$/$SQL procedure successfully completed.