Question: simple code Write PL/SQL code to create a procedure called Manager_info that returns the name of the manager, managed department name and how many employees

simple code

Write PL/SQL code to create a procedure called Manager_info that returns the name of the manager, managed department name and how many employees under his management. When you call the procedure with a manager id, the procedure will returns the name of the manager, managed department name, total number of managed employees.

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!

create a procedure called Manager_info that returns the name of the manager, managed department name and how many employees under his management. When you call the procedure with a manager id, the...

in Oracle Database 10g Express Edition and on hr schema and plz test the codes Q1. Write PL/SQL code to create a function called total_salaries that returns the total salaries of all employees who...

please check the code if you don't have oracle database don't do it and please answer the 3 questions right I need it asap in Oracle Database 10g Express Edition and hr schema Q1. Write PL/SQL code...

This is the second time that I submit this project, the solution was wrong, if you would be so kind to solve the project for me correctly and completely and in SQL language with a screenshot of the...

Activity A (20 points) Database creation Do not consider primary and foreign keys for this assignment C reate a database named company. Create a table in this database. Named: departments The...

Draw an ERD for each of the 2 business cases below. Be sure to show the entities, the attributes (if any specified) and the relationships including maximum and minimum cardinalities. List any...

1. Use the following business rules to create a Crows Foot ERD. Write all appropriate connectivity and cardinalities in the ERD. A department employs many employees, but each employee is employed by...

I need help In these ERD problems in Data Base Design, you can do them by hand writing or using computer. PR OB LE M S g business rules to create a Crow's Foot ERD. Write all appropriate...

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

Following are Newman projections for the three tartaric acids (R,R), (S,S), and meso. Which is which? CO,H CO,H OH HO HO CO,H CO H CO H

Visit the Canadian Institute of Chartered Accountants website (www.cica.ca). How much emphasis is placed on forensic accounting? How does a person become a forensic accountant?

Prakesh Company has the following data for one of its manufacturing cells: Maximum units produced in 1 month: 50,000 units Actual units produced in 1 month: 40,000 units Hours of production labor in...

Can someone help me with this question please. COST OF EQUITY WITH AND WITHOUT FLOTATION Jarett & Sons's common stock currently trades at $28.00 a share. It is expected to pay an annual dividend of...

Compare the difference between job descriptions and job specifications.

Understand the process of Run, Hide, Fight during an active shooter situation.

Create a workflow analysis.