Write a pl/sql block that displays the last name


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:
The highest paid employee
The lowest paid employee
The average salary of all employees

Part 2. Embed a stored procedure and call it (must be done from SQL Command Line), providing printscreens demonstrating that the PL/SQL blocks return the correct responses upon being executing the stored procedure.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write a pl/sql block that displays the last name
Reference No:- TGS0135704

Expected delivery within 24 Hours