2. write a SQL procedure called min max that takes department name as input and returns...

Question

Question

2. write a SQL procedure called min max that takes department name as input and returns maximum and minimum salary of the dep

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

CREATE OR REPLACE PROCEDURE
min_mx
   (
   dept_name IN varchar,
   min_price OUT int,
   max_price OUT int
   ) RETURN
AS
BEGIN
   SELECT MIN(salary), MAX(salary) INTO min_price, max_price FROM DEPT_TABLE WHERE department_name=dept_name
END;

COMMENT DOWN FOR ANY QUERY

PLEASE GIVE A THUMBS UP

Add a comment

Answer 2

Similar Homework Help Questions

Write a C function called min which takes 2 integers as input, and returns the smallest...

Write a C function called min which takes 2 integers as input, and returns the smallest as the result?
Create a PL/SQL procedure that takes department ID as an input and prints the details of...

Create a PL/SQL procedure that takes department ID as an input and prints the details of all the students including the Student ID (represented as StuID), name, and the description of the major that they are currently enrolled in. You may use the following procedure template: CREATE OR REPLACE PROCEDURE Student_Major (I_deptID IN Student.DeptID%type) AS CURSOR c1 is ... ... BEGIN ... END Student_Major;
Matlab: Write a function called minimax that takes M, a matrix input argument and returns mmr,...

Matlab: Write a function called minimax that takes M, a matrix input argument and returns mmr, a row vector containing the absolute values of the difference between the maximum and minimum valued elements in each row. As a second output argument called mmm, it provides the difference between the maximum and minimum element in the entire matrix. See the code below for an example: >> A = randi(100,3,4) A = 66 94 75 18 4 68 40 71 85 76...

Write a function called ''minandmax'' . Function ''minandmax'' takes only one input argument that is a...

Write a function called ''minandmax'' . Function ''minandmax'' takes only one input argument that is a matrix M . This matrix M can be any size (any number of columns and rows) with any random integer values . Function ''minandmax'' returns two output arguments. The first output argument is called ''difference_row'' that returns a row vector containing the absolute values of the difference between the maximum and minimum valued elements in each row. The second output argument is called ''difference_all''...
Write a procedure called insert_emp which inserts a new employee into f_emps. Pass the employee id,...

Write a procedure called insert_emp which inserts a new employee into f_emps. Pass the employee id, last name, salary, and department id to the procedure as IN parameters. The procedure should call your check_dept function to verify that the passed department id exists in the f_depts table. If it exists, insert the employee. If it does not exist, use DBMS_OUTPUT.PUT_LINE to display a suitable error message. Save your code.
java code Write a method called reverse that takes an array of integers as an input...

java code Write a method called reverse that takes an array of integers as an input and returns the same values in reverse order as the output. Test your method in the main.

Saved BlockPy: #33.8) Maximum Odd Use the Min/Max pattern to write a function maximum_odd that finds...

Saved BlockPy: #33.8) Maximum Odd Use the Min/Max pattern to write a function maximum_odd that finds the highest odd value in the list (consumes a list of numbers and returns a number). Use the provided helper function is_odd (that consumes a single number and returns a boolean indicating whether it is true or false). Do not change the helper function is_odd. Call your maximum_odd function on your favorite list of numbers. Server Execution: Idle Feedback: Ready Console Run "Blocks 艹Split...
Write a public static method named getMaxOf2Ints that takes in 2 int arguments and returns the...

Write a public static method named getMaxOf2Ints that takes in 2 int arguments and returns the Maximum of the 2 values Write a public static method named getMinOf2Ints that takes in 2 int arguments and returns the Minimum of the 2 values Write apublic static method named getMaxOf3Ints that takes in 3 int arguments and returns the Maximum of the 3 values Write a public static method named getMedianOf3Ints that takes in 3 int arguments and returns the Median Value...
BlockPy: #33.8) Maximum Odd Use the Min/Max pattern to write a function maximum_odd that finds the...

BlockPy: #33.8) Maximum Odd Use the Min/Max pattern to write a function maximum_odd that finds the highest odd value in the list (consumes a list of numbers and returns a number). Use the provided helper function is_odd (that consumes a single number and returns a boolean indicating whether it is true or false). Do not change the helper function is odd. Call your maximum_odd function on your favorite list of numbers Console Feedback: Instructor Feedback You cannot use the builtin...

Write a program to run the following methods in C#. 2) Write a method that takes...

Write a program to run the following methods in C#. 2) Write a method that takes in a teacher’s last name and exam number via parameters. Ask the teacher (using her name) to tell you the highest score on that exam. Your question should look something like “Ms. Jones, what was the highest grade on test two?” Return the value of the highest grade to the calling method. 3) Write a function called MinOfThree that takes in three numbers and...

2. write a SQL procedure called min max that takes department name as input and returns...

Homework Answers

Add Answer to:
2. write a SQL procedure called min max that takes department name as input and returns...

Post as a guest

Earn Coins

Write a C function called min which takes 2 integers as input, and returns the smallest...

Create a PL/SQL procedure that takes department ID as an input and prints the details of...

Matlab: Write a function called minimax that takes M, a matrix input argument and returns mmr,...

Write a function called ''minandmax'' . Function ''minandmax'' takes only one input argument that is a...

Write a procedure called insert_emp which inserts a new employee into f_emps. Pass the employee id,...

java code Write a method called reverse that takes an array of integers as an input...

Saved BlockPy: #33.8) Maximum Odd Use the Min/Max pattern to write a function maximum_odd that finds...

Write a public static method named getMaxOf2Ints that takes in 2 int arguments and returns the...

BlockPy: #33.8) Maximum Odd Use the Min/Max pattern to write a function maximum_odd that finds the...

Write a program to run the following methods in C#. 2) Write a method that takes...

2. write a SQL procedure called min max that takes department name as input and returns...

Homework Answers

Add Answer to: 2. write a SQL procedure called min max that takes department name as input and returns...

Post as a guest

Earn Coins

Add Answer to:
2. write a SQL procedure called min max that takes department name as input and returns...