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.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.
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: