Question: 1- Write a PL/SQL procedure named Salary_Report to show the number of salaries in each category as follows: If the salary of Instructor is less

1- Write a PL/SQL procedure named Salary_Report to show the number of salaries in each category as follows: If the salary of Instructor is less than the average salary then the category is LOW Else the category is HIGH. The stored procedure must print how many of LOW and HIGH recordings are available in the database.

2- What type of PL/SQL cursors are available? What is the purpose of them, explain with an example.

3- For each school code, write SQL query to display school code and how many instructors work for that school. Include only schools that involve more than one instructor. Sort the output so that school codes with the most instructors involved are shown first.

4- Write SQL query to display last name and salary for all instructors who earn less than the Lowest salary in ANY school. Sort the output by top salaries first and then by last name. You must use sub-query.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

) Explain the collision detection mechanism applied in standard wired medium access control associated with CSMA and indicate why this might be unsuitable for wireless networks. [2 marks] (ii)...

use PL/SQL stored procedures to 1. Write a store procedure that get an integer number and prints The number is even. If a number is divisible by 2. Otherwise, it prints The number is odd. 2. Create a...

Create a Pl/SQL subprogram, which has two blocks. An outer block declares two variables named x and counter and loops four times. Inside this loop is a sub-block that also declares a variable named...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

In the Intro to Purchasing and Supply Chain reading, Page 6, Figure 1-2, there is a comparison of Traditional Purchasing versus the Current Outlook. Provide three reasons why the Current Outlook is...

Deposit Rules for Glo-Brite Paint Company The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in w Federal taxes were withheld. Since Glo-Brite is a...

Beginning PL/SQL Please answer a-e below. Please say what letter you are answering. Create a test table called Emp2 that is similar to the Worker table Use CREATE TABLE Emp2 AS SELECT * FROM Worker)....

QUESTION 9 How will your in-text referencing be done for a source with two authors now will your in-text referencing be done for a source with two authors A. (Bothma and Viljoen, 2005:101) B. (Bothma...

A recent survey found that, despite airline requests, about 40% of passengers dont fully turn off their cell phones during takeoff and landing (although they may put them in airplane mode). The two...

Which are reasons not to depend on Social Security as a retirement plan? toose all that apply. There is no money in "your account." You cannot collect full retirement benefits until you are 6 5 . The...

The comparative balance sheet of Hirayama Industries Inc. for December 31, 20Y2 and 20Y1, is as follows: The following additional information is taken from the records: 1. Land was sold for $153. 2....

Rewrite Listing 16.13, ImageAudioAnimation.java, to use the resource bundle to retrieve image and audio files. (Hint: When a new country is selected, set an appropriate locale for it. Have your...

Resulting from a light wind, the air pressure imbalance of 100 Pa acts across the 1.2-m by 2-m surface of the highway sign (Figure P4.11, see on page 172). (a) Calculate the magnitude of the force...

Compute a map representing the last function used in the Boyer-Moore patternmatching algorithm for characters in the pattern string: "the quick brown fox jumped over a lazy cat".

Find the closed-loop transfer function of the Unmanned Free-Swimming Submersible vehicles pitch control system shown on the back endpapers (Johnson, 1980).

critical path for project management for VTO technology in Duty-free

A recent survey of New York State families asked about their vacation habits. The accompanying two-way table shows the number of families according to where they live (rural, suburban, urban) and the...

Beer is Americans preferred alcoholic beverage. It is estimated that 90 million Americans drink beer and that as much as 20% of all alcohol is consumed by underage persons, with a large portion of...

We are interested in estimating the mean life of a new product. How large a sample do we need to take to estimate the mean to within 1/10 of a standard deviation with 90% confidence?

Based in Italy, Datura, Ltd., is an international importer-exporter of pottery with distribution centers in the United States, Europe, and Australia. The company was very successful in its early...

Repeat the simulation using the sample size n = 10. Draw the histogram using bins 1.0, 1.5, 2.0, . . . 6.0. Compare this histogram with the one you created in Exercise 9.1. Describe the differences...

Repeat the experiment calculating the sample variances (Excel function VAR). If the sample variance is an unbiased estimator of the population variance, what value should be observed when you...