simple code

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.