77 357
Assignments Done
Successfully Done
In July 2019

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

Question #43704
*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 )
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

Privacy policy Terms and Conditions