Question: Write pl/sql code to display each job type along with number of employees working under this job, as show below. Output will be like: ******

Write pl/sql code to display each job type along with number of employees working under this job, as show below.

Output will be like:

  1. ****** CLERK *******
  2. total number of employees : 4
  3. ****** SALESMAN *******
  4. total number of employees : 4
  5. ****** ANALYST *******
  6. total number of employees : 2
  7. ****** MANAGER *******
  8. total number of employees : 3
  9. ****** PRESIDENT *******
  10. total number of employees : 1

Note:

1-Use explicit cursor.

2-Use for loop.

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!

Q:

Write pl/sql code to display each job type along with number of employees working under this job

Q:

073 5:47 ADRE X Assignment#... Saved on device Assignment#5 1. Write pl/sql code to display each job type along with number of employees working under this job, as show below. 5. Output will be like:...

Q:

Hello, i need help with SQL Since i am not able to use it myself, i would kindly appreciate if you answer the questions SQL queries and also the result of the query in a table form have to be...

Q:

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

Q:

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

Q:

Futura Industries Remember the last time you walked through a grocery store? Did you notice all of the shelves holding the food? If you are like most people, you probably did not pay much attention...

Q:

Overview of Compostwizard Pty Ltd Darlene Daylight is the inventor of the Compostwizard. The Compostwizard is a solar driven digging device approximately 1.5 metres in length, containing a carbide...

Q:

I've attached the assignment as a word file, thanks! JWCL165_c07_304-355.qxd 7/31/09 2:05 PM Page 304 7 Fraud, Internal Control, and Cash Chapter STUDY OBJECTIVES After studying this chapter, you...

Q:

txt file 12 swa Elon 9 0 0 0 qae Les 0 0 10 0 swe Todd 0 9 7 0 qae Jamey 0 0 8 0 swm Jeff 0 0 0 9 swe John 0 9 9 0 swe Eric 0 10 9 0 qae Darrel 0 0 9 0 swe Ariel 0 9 10 0 qae Joanne 0 0 8 0 swa Tim...

Q:

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

Q:

Net Advantage from Leasing This question has seven parts. Terra Enterprises is trying to determine whether leasing would be a better alternative than purchasing $2.5 million of new equipment. The...

Q:

As transportation manager at ABC Manufacturing, you are trying to determine whether there is a useful linear relationship between x, the distance that your product is shipped, and y, the amount of...

Q:

Spilker Taxation of Individuals and Business ntities UWorld CPA Review Qu . 0 8 0 UWorld Which of the following would be a separately stated item on Schedule K - 1 of an S Corporation's Form 1 1 2 0...

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

Discuss three reasons why recruiting is important to organizational success.

Q:

Evaluate the importance of diversity in the workforce.

Q:

Identify the legal standards of the recruitment process.