August 2002
Intermediate to advanced
528 pages
10h 12m
English
| 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 ... |