Question: Create a stored procedure or function called GET_SERVICE_YRS to retrieve the total number of years of service for a specific employee using employee number. Add

Create a stored procedure or function called GET_SERVICE_YRS to retrieve the total number of years of service for a specific employee using employee number. Add appropriate error handling to account for an individual employee number.

Step by Step Solution

★★★★★

3.40 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Heres a stored procedure using MySQL syntax that incorporates error handling SQL DELIMITER CREATE PR... View full answer

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!

1 Create a PL/SQL block to declare a cursor EMP_CUR to select the employee name, salary and hiredate from emp table. Process each row from the cursor, and if the salary is greater than 4000 and the...

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...

Can you help me change this in c++ update your payroll program to use a C++ class. Each employee class object should hold the master file information for one employee. You can assume that the company...

Technology guru Tim O'Reilly said this about the publishing industry: " To adapt, publishers need to cannibalize their own business, experimenting with new forms, new formats, and new business...

Was philosopher Rawls more concerned with the relative well-being of the less fortunate compared to the more fortunate, or was he more concerned with the absolute well-being of the less fortunate?

McDowell Industries sells on terms of 3/10, net 30. Total sales for the year are $912,500. Forty percent of the customers pay on the 10th day and take discounts; the other 60 percent pay, on average,...

Interview an individual (e.g. family member, neighbour) across a holiday period: four days before (pre-vacation), directly after (post-vacation 1) and four days after the holiday (post-vacation 2)....

Arcus Development Inc.s equity section on the December 31, 2013, balance sheet showed the following information: Common shares, unlimited shares authorized, 150,000 shares issued and...

The following income statement accounts have been taken from the annual report for a commercial bank: Provision for loan losses $ 20,000 Interest paid on deposits under $ 100,000 $35,000 Salaries and...

Cody Jenkins and Lacey Tanner formed a partnership to provide landscaping services. Jenkins and Tanner shared profits and losses equally. After all the tangible assets have been adjusted to current...

Find the area bounded by the parabola y^2 = 4ax and its latus rectum.

Choose a company currently operating in the UK (it does not have to be British in origin). Evaluate the following aspects of the company in question: Organisational Structure Organisational Culture...

Thinking about your natural negotiation style, ask yourself: In general, when does your style help you and when does it not help you in negotiation situations? Now, think about how you can translate...

There are three (3) columns, the first column is the reduction of prevention costs, second column is progressive reduction of appraisal costs, and the last column is reduction of failure costs. 2.In...

( Scenario 1 4 - 1 ) After it launched, PlayWithMe contracted with three major search engines to show its advertisements any time a user searched for certain terms that were closely identified with...

There are three different methods commonly used for capturing network data. These are (1) using a network tap, (2) using a SPAN port on a switch, and (3) using a tool built into a network device...

A company expects a creditor to repay $30,341, 23 years from today. What is the equivalent value in today's dollars if the company's opportunity cost of capital is 12% p.a. compounded quarterly?...

Distinguish between the work performed by public accountants and the work performed by accountants in commerce and industry and in not-for-profit organisations.

Generate a listing of all purchases made by the customers, using the output shown in Figure P7.28 as your guide. ODE | INV-NUMBER | INV-DATE 10011 P DESCRIPT LINE UUNITS LINE PRICE 4.99 1002...

Modify the ERD you created in Problem 25 to eliminate the problems created by the use of synonyms.

Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure into a dependency diagram that is in at least 3NF.

The autonomic nervous system is also referred to as the skeletal nervous system. controls the glands and the muscles of our internal organs. is a voluntary system under our conscious control....

The neuron fiber that passes messages through its branches to other neurons or to muscles and glands is the _______.

The lower brain structure that governs arousal is the spinal cord. cerebellum. reticular formation. medulla.