Answer to Question #43704 in Databases | SQL | Oracle | MS Access for sekher kumar

Question

*Create a package EMP_PACK contain one two function and one procedure.
a) Procedure EMP_REP: accept deptno and generate same report as [ Write a PL/SQL block which accept job from the user . If there are only employees
then display the details otherwise raise an exception with proper message. If there are
more than one employees then raise an exception with the no of employees and their
names together separated by “,”. For other runtime error terminate the block showing
message. ]
b) Function BONUS: Return bonus by empno accept as parameter.
c) Function CHK_DEPTNO: accepts only deptno as parameter and return T/F to the
EMP_REP. ( Private )