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 )
0
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!

Comments

No comments. Be first!

Leave a comment

Ask Your question

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS