Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me solve this Write a PL/SQL stored procedure to print number of employees who are working in a job with Title Tester. Include

image text in transcribedPlease help me solve this

Write a PL/SQL stored procedure to print number of employees who are working in a job with Title "Tester". Include procedure call also. If the total count of Employees is more than 5 then print "Sufficient number of Employees" If the total count of Employees is less than 5 then print "Insufficient number of Employees" Else print "there are 5 employees". Use Oracle's NO_DATA_FOUND build in exception to display the last message. DEPARTMENTS P DEPARTMENT_ID * DEPARTMENT_NAME MANAGER_ID LOCATION_ID JOB HISTORY PF EMPLOYEE_ID P *START_DATE * END DATE F * JOB_ID F DEPARTMENT_ID LOCATIONS P * LOCATION_ID STREET_ADDRESS POSTAL CODE * CITY STATE PROVINCE COUNTRY_ID IP COUNTRIES COUNTRY_ID COUNTRY_NAME REGION_ID IF JOBS P - JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY EMPLOYEES IP EMPLOYEE_ID FIRST_NAME LAST NAME U EMAIL PHONE NUMBER * HIRE_DATE F * JOB_ID SALARY COMMISSION_PCT MANAGER_ID F DEPARTMENT_ID V REGIONS P REGION_ID REGION_NAME

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

Data Management Databases And Organizations

Authors: Watson Watson

5th Edition

0471715360, 978-0471715368

More Books

Students also viewed these Databases questions

Question

Were the right people involved in the decision-making process?

Answered: 1 week ago

Question

Were they made on a timely basis?

Answered: 1 week ago