Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Implementation

Authors: Shouhong Wang, Hai Wang

1st Edition

1612330150, 978-1612330150

More Books

Students also viewed these Databases questions

Question

Evaluate the importance of diversity in the workforce.

Answered: 1 week ago

Question

Identify the legal standards of the recruitment process.

Answered: 1 week ago