Question: Write a stored procedure called show_stars that gets an integer as its IN parameter. For a given employee id, you need to find out

Write a stored procedure called show_stars that gets an integer as its IN parameter. For a given employee id, you need to find out employee's Last Name, also salary, and "salary note" that is a sequence of asterisks (*) -- constructed by dividing salary by 2000 and taking only the integer portion (i.e. note will have One Asterisk for each $2,000 earned). Use our table Employee. (For 5 marks) Here are some relevant testings shown: SQL> execute show_stars(124); Name is Mourgos and the salary is 5800 and the note is ** PL/SQL procedure successfully completed. SQL> execute show_stars(176); Name is Taylor and the salary is 8600 and the note is **** PL/SQL procedure successfully completed. SQL> execute show_stars(99); This person does NOT exist PL/SQL procedure successfully completed.

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!

TicTacToe Assignment March 28 100 points (no late assignments accepted) Review class notes #18 and do the following: Use the program tictac16 and answer the following questions: What is the data...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...

Creating Stored Procedures Write a stored procedure called ` pro _ view _ employee ` that accepts an employee ID as an input parameter and retrieves the employee's last name, first name, salary, job...

Please follow the instructions below: 1. Please add whats listed below to the code that will be provided under this 2. Add a new class called PayrollSystem_Phase2 . 3. Add the main method provided...

Relational Database Design and SQL For each question, write the SQL statements required to generate the required results. 1. Create a stored procedure called store_information which takes one input...

Relational Database Design and SQL Please answer as soon as possible For each question, write the SQL statements required to generate the required results. 1. Create a stored procedure called...

PL / SQL homewerk help needed. I ' m using SQL developer. Please use PL / SQL and use SQL Developer Here is the questions below: 1 . The Raise Procedure ( 4 0 points Create a copy of the EMPLOYEES...

Description A company is planning to hire a number of temporary workers who are paid hourly and you are given a data file that contains the last name of the employees, the amount of hours worked by...

In T-SQL Please. I would really appreciate it! Please fulfill the requirements stated below with the following database: /*use master; GO Alter database Project3 set single_user with rollback...

Suppose that |ak| |bk| for large k. Prove that if k=0 bkxk converges on an open interval I, then k=0 akxk also converges on I. Is this result true if open is omitted?

Is there a strictly monotone onto function f : R Q R? Justify your answer.

Landon Inc. is preparing its cash budget. The sales budget specifies the following budgeted monthly sales, in units: April .......................................... 9,000 May...

What is a business case? How does a business case affect an IT project?

Why do you think Wilson was appointed Director?

Refer to Assignment 5 in Chapter 17. Draft an opinion letter to Mrs. Dixon informing her of the results of your research and the likelihood that the holographic will submitted by Mary Cary will be...

1. How would you describe Danielle Oviedo's approach to leadership? 2. What would you predict about Danielle's future success as a leader? Why? 3. In what ways, if any, does Danielle function as a...

How are a growing annuity and growing perpetuity similar?Group of answer choicesNeither has an endBoth have payments that increase by a constant amount over timeBoth have payments that increase at a...

Ted was a wealthy, 20% shareholder of TDS Corporation. He was looking over the financial statements of the corporation and saw that TDS Corporation was in need of a large loan. Furthermore, he knew...

Purpose: To help you understand and compare the performance of two companies in the same industry. Find the Bombardier Annual Report, Year Ended January 31, 2011 located in MyAccountingLab. Now...

Patel Ltd.'s new accounting clerk could not get the bank reconciliation balanced. He needs your help and provided you with his bank reconciliation and all the information he used to prepare the bank...

=+41. Ultra high performance concrete (UHPC) is a relatively new construction material that offers strong adhesive properties with other materials.The authors of Adhesive Power of Ultra High...

=+successes occur three times as frequently in population 1 as they do in population 2. Alternatively, if the s refer to success proportions for two different treatments, then a ratio of 3 implies...

=+28. The article The Effects of Cigarette Smoking and Gestational Weight Change on Birth Outcomes in Obese and Normal-Weight Women (Amer.