Write a simple PL/SQL function which has the following definition. Refer to the "EMP" below for appropriate column names CREATE TABLE emp ( empno number(4) CONSTRAINT pk_emp PRIMARY KEY, ename varchar2(10) NOT NULL, job varchar2(10), mgr number(4) referneces emp ON DELETE CASCADE, hiredate date, sal number(6), comm number(6), deptno number(3), CONSTRAINT fk_emp_deptno FOREIGN KEY (deptno) REFERENCE dept ON DELETE CASCADE) ------------------------------------------------------------------- Function name: Count_Emp Purpose: To count the number of managers from the EMP table Input parameter: employee job type ( is the employee an emp or mgr) Output parameter: None Input/Output parameters: None Return Value: an integer value representing the total number of managers. Precondition: None Postcondition: the employee table is unchanged. The output of the function is the number of managers in the emp table Use % TYPE where possible.
Write a simple PL/SQL function which has the following definition. Refer to the "EMP" below for appropriate column names CREATE TABLE emp ( empno number(4) CONSTRAINT pk_emp PRIMARY KEY, ename varchar2(10) NOT NULL, job varchar2(10), mgr number(4) referneces emp ON DELETE CASCADE, hiredate date, sal number(6), comm number(6), deptno number(3), CONSTRAINT fk_emp_deptno FOREIGN KEY (deptno) REFERENCE dept ON DELETE CASCADE) ------------------------------------------------------------------- Function name: Count_Emp Purpose: To count the number of managers from the EMP table Input parameter: employee job type ( is the employee an emp or mgr) Output parameter: None Input/Output parameters: None Return Value: an integer value representing the total number of managers. Precondition: None Postcondition: the employee table is unchanged. The output of the function is the number of managers in the emp table Use % TYPE where possible.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
there is no information provided for the solution ,in the question says:
The output of the function is the number of managers in the emp table Use % TYPE where possible.
The Given attribute is not present in the employee table which means the count.
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)