IT358 Unit 9 PL/SQL Stored Procedures
Outcomes addressed in this activity:
Use PL/SQL Block Structures
Identify different types of blocks used in PL/SQL
Demonstrate the ability to output messages using PL/SQL
IT358-5 Write stored procedures to meet business needs
Part 1. Write a PL/SQL block that displays the last name and salary of the following people. Each of these can be done separately as PL/SQL, first to test and get the output lines then encapsulated in the procedure and then called, or all in one piece of code like #2 if student is comfortable with writing it all as one program. In this second option student would submit three print screens and in the first option six print screens:
a. The highest paid employee
b. The lowest paid employee
c. The average salary of all employees
Part 2. Embed a stored procedure and call it (must be done from SQL Command Line), providing print screens demonstrating that the PL/SQL blocks return the correct responses upon being executing the stored procedure.
Place the answers to #1 and #2 in an MS Word Document. Also copy and paste your scripts and print screens into the same MS Word document and upload the file to Assignment 9 in the Dropbox.