in Oracle Database 10g Express Edition and on hr schema and plz test the codes

Q1. Write PL/SQL code to create a function called total_salaries that returns the total salaries of all employees who are working in X department or working as Y job title or working in Z country name. When you call the function, you have to pass your choice parameter and the department name or job title or the country name. The function will return the total salaries of employees who are working in that given department or job title or country name

Q2. Write PL/SQL code to create a procedure called Manager_info that returns the name of the manager, managed department name and how many employees under his management. When you call the procedure with a manager id, the procedure will returns the name of the manager, managed department name, total number of managed employees.

Q3.Write PL/SQL code to create package called CSC325_PACKAGE that use the function and procedure that you create them in the questions above in addition to one more function and one more procedure of your choice. Show the usage of the package procedures and function. You need to use one exception( Oracle exception or user exception)

u have to attach with:

Source Code

Screenshots of the execution results