Pl-sql block to display last name and salary

Assignment Help PL-SQL Programming

Reference no: EM1355777

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.

Reference no: EM1355777

Questions Cloud

Determine the goal of negotiating : Determine the goal of negotiating? Discuss and explain why is planning critical to the negotiation processand when would an organization negotiate for an item or product instead of releasing a simple purchase order?

Calculating total inventory destroyed in fire : A fire completely destroyed the entire inventory of Printing Delight Company on April 10, 2014. Fortunately, the books were not destroyed in the fire. The following information is taken from the books of Printing Delight Company for January 1 to A..

Canadian code of ethics for psychologists : Which Decision Making Model Do YOU prefer? Choose one: The model outlined in Bersoff's commentary on p.146 - 147, OR the Ethical Decision Making Process as outlined in the Canadian Code of Ethics for Psychologists

Elucidate the resulting paint cost per gallon : Illustrate what percentage of G1 can be mixed with G2 and still satisfy the customers. Elucidate the resulting paint cost per gallon.

Pl-sql block to display last name and salary : 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.

Assessment of dynatronics financial performance : Determine assessment of Dynatronics' financial performance over the period 1986-1988? What strengths or weaknesses, if any, do you see?

What was the angular speed of the wheel at the beginning : An object has a kinetic energy of 303 J and the momentum of magnitude 22.9 kg·m/s. Find the speed and the mass of the object.

Psychological testing versus ongoing psychotherapy : whether such limitations should be different depending upon the nature of the service provided (i.e., psychological testing versus ongoing psychotherapy). Provide at least one valid reference.

Find the magnitude of the electric field in the wire : A copper wire has a square cross section 2.7 on a side. The wire is 3.8 long and carries a current of 4.0 . The density of free electrons is 8.5*10^28 m^-3.

User Account

All Pages