Question: 3. Create a stored function, using the syntax of either PL/SQL or mysql, which will accept an input parameter of employee id, eid, and which

3. Create a stored function, using the syntax of either PL/SQL

3. Create a stored function, using the syntax of either PL/SQL or mysql, which will accept an input parameter of employee id, eid, and which will output his 'monthly salary', assuming that the salary field in the employees table is an annual salary. Discuss how to get the function compiled and stored, and also give an example of how to invoke the function in SQL

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!

c++ The code you need to use company.cpp: #include #include #include #include #include using namespace std; class Company { public: Company(string name, int size); //Initializes the company object so...

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

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 59.3 26.5 34.1 56.3 46.8 79.5 41.2 23.6 76 22.7 23.8 62.9 41.4 22.3 23.1 46.6 67.6 33.8 24 35 75.2 51.5 22.1 55.4 24.9 24.3 42.9 76.6 75.4...

ID Salary Compa- Midpoint ratio Age Performance Service Gender Rating Raise Degree Gender Grade 1 Copy Employee Data set to this page. The ongoing question that the weekly assignments will focus on...

PLEASE ANSWER THE QUESTION CORRECTLY AND ACCURATELY. ENSURE YOU SHOW THE CORRECT CODE AND THE OUTPUT THAT THE CODE RUNS ON THE SCREEN. ALL THE HEADER AND CLASS FILES ARE GIVEN REQUIRED FOR THE...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

"Fortran, Algol and Lisp invented most programming language concepts 50 years ago; adding the concept of object-orientation suffices to explain all programming languages to date". To what extent is...

This question involves the use of AGGREGATE linear PYTHOIN regression on the Auto data set. (a) Perform a simple linear regression with mpg as the response and horsepower as the predictor. Describe...

The Language is Java. Please post code for the following steps 17-23. Thank You in advance. Scenario - OraclProduction OraclProduction Ltd are specialists in producing production line manufacturing...

26. Draw a triangle ABC so that a = 4,c=5, and ZB = 120. Find side b. 27. Draw a triangle ABC so that a = 10,b= 12, and c = 16. Find ZB.

Kevin Spears, the accountant of Tyler Electronics Inc., has prepared the following information for the company's inventory at the end of 2009: Required: Determine the carrying amount of the inventory...

what is the key difference between direct investment and portfolio

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+international assignments and the issue of failure in an IA assignment and reasons for it.

=+j What compensation strategy does the organization want to pursue? That is,

=+j Describe the characteristics of successful IA selection programs and exemplary practices.