View the step-by-step solution to:

I'm not sure how to create these queries Write a PL/SQL block that displays the last name and salary of the following people.

I'm not sure how to create these queries
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 Block SQL Structure within a Stored Procedure and Call it providing printscreens demonstrating that the PL/SQL blocks return the correct responses upon being executing the Stored Procedure.



Any help would be appreciated

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question