Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

1:	Create a program that outputs the message “I am soon to be a PL/SQL expert.”
2:	Create a PL/SQL procedure that has four sections. Each section should output a statement. Use labels and the GOTO command to output the section messages in the following order: Section 3 Section 2 Section 1 Section 4
3:	Create a PL/SQL procedure that computes the retirement age of the youngest employee. You should also list the employee’s name.
4:	Modify the program in Question 3 to compute the number of days between today and the employee’s retirement date.
5:	Identify the number of tool purchases for Harold Truman and George Bush. Output the name of the employee with the greater number of tool purchases.
6:	Use a nested IF statement to the Question 5 PL/SQL ...