Create a procedure in PLSQL to display the count of employees having department as “Marketing”. (Table needs to be created as per requirement of the question.) Note: Paste the code for table creation also along with the procedure code.

Question

AK

Asked: November 11, 20212021-11-11T00:15:02+05:30 2021-11-11T00:15:02+05:30In: DBMS

Create a procedure in PLSQL to display the count of employees having department as “Marketing”.

(Table needs to be created as per requirement of the question.)

Note: Paste the code for table creation also along with the procedure code.

You must login to add an answer.

Need An Account,

Professor · Answer 1 · 2021-11-13T19:40:20+05:30

Professor

CREATE OR REPLACE PACKAGE EMP AS

PROCEDURE find_dept(e_dept employee.dept%type);

END EMP;

. . . . . . . . . . . . . . . . .

SHOW SOME SUPPORT FRIENDS VOTE UP THE ANSWER

THE FULL ANSWER IS IN THE ATTACHMENT JUST TAP ON IT:

SIKSHAPATH Latest Questions