Question: 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

Please help me solve this Write a PL/SQL stored procedure to printPlease 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

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!