Answered step by step
Verified Expert Solution
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
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 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_NAMEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started