Write pl-sql block to display the last name of people

Assignment Help PL-SQL Programming

Reference no: EM1364773

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.

Reference no: EM1364773

Questions Cloud

Operating leverage-roi-eva : Use information from the latest financial statement to compute operating leverage, ROI, EVA and another performance measure of Textron,

Introduction to project plan : Discuss what each of those plans should contain. Also, discuss the challenges the project manager faces in achieving each of those plans.

At what angle should the road be banked : At what angle should the road be banked. The charge on the inner shell is 4.59 x 10- 8 C and that on the outer shell is 2.15 x 10- 8 C. Find out the electric field (in N/C) (a) at r = 12.7 cm and (b) at r = 37.3 cm.

Comparison of formal research and business proposals : What are some differences? What are the capabilities of one in contrast with the capabilities of the other?

Write pl-sql block to display the last name of people : 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.

Discusses debits and credits : Define the terms debit and credit. Explain how debits and credits affect the following: assets, liabilities, owner's capital account, revenues and expenses.

Calculate required down payment : The Smiths are purchasing a home that sells for $175,000. The lending institution is requiring a minimum down payment of 20%. To obtain a 20 year mortgage at 8 percent,

Calculating federal tax due : Sheniqua, a single taxpayer, had taxable income of $73,239. Her employer withheld $14,077 in federal income tax from her paychecks throughout the year. Using the tax tables

Limitations of inventory control models such as eoq : What do you think can be the limitations of inventory control models such as EOQ, continuous-review, and periodic-review models?

User Account

All Pages