Write pl-sql block which displays last name

Assignment Help PL-SQL Programming

Reference no: EM1369184

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.

Reference no: EM1369184

Questions Cloud

Describe how single-user system scheme works : Give a real-life example of a single-user system scheme, fixed partitions, dynamic partitions, and relocatable dynamic partitions. Describe how process works.

Transformation plan for the company bp : Transformation plan for the Company BP and prepare a transformation plan for the Company BP

Find the direction of the force at the support point : A diving board of length 3 is supported at a point 1 from the end, and a diver weighing 480 stands at the free end. The diving board is of uniform cross section and weighs 295.

Find the profitability : Profitability will also be increased by cost reductions accomplished through supplier partnering programs. New customers will be acquired through social network marketing and word of mouth.

Write pl-sql block which displays last name : Write PL/SQL block which displays last name and salary of following people. Each of these can be done separately as PL/SQL, first to test and get output lines

What is the new coefficient of friction : A 62 kg person on skis starts from rest down a hill sloped at 40° from the horizontal. The coefficient of friction between the skis and the snow is 0.10.

Aggregate supply aggregate demand graphs : You observe that output is above full-employment output. Politicians are discussing about the possible reasons. One party claims that this is due to a drop in world oil prices.

Find the final volume of gas : If a metric ton is 1 x10^3 kg, how many 88 kg people can safely occupy an elevator that can hold a maximum mass of exactly 1 metric ton.

Show the progressive discipline procedure : Understand what consideration should managers and employees be aware of while inpositive discipline procedures. and how the effect the employment-at-will priniciple on the approach.

User Account

All Pages