GetManagerOfEmployeeById

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   EMPLOYEES   >   GetManagerOfEmployeeById

Procedure body GetManagerOfEmployeeById(id NUMBER), Package EMPLOYEES

Name	Datatype	Precision	Description
id	NUMBER		NUMBER, parameter of EMPLOYEES.GetManagerOfEmployeeById

Name	Types	Value
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.EMPLOYEES.GetManagerOfEmployeeById Procedure

Name	Definition
c1	cursor c1 is SELECT manager_fname FROM ALL_EMPLOYEES_DETAILS where emp_id = id;

procedure GetManagerOfEmployeeById(id in NUMBER )
    Is 
	cursor c1 is
			SELECT manager_fname
			FROM ALL_EMPLOYEES_DETAILS where emp_id = id;

	
    Begin
		for r1 in c1 loop
        dbms_output.put_line(
            lpad(r1.manager_fname,12)
        );
		end loop;

    end GetManagerOfEmployeeById

Name	Types	Description
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS	View	View
<DEFAULT SCHEMA>.EMPLOYEES.GetManagerOfEmployeeById	Procedure	Procedure interface GetManagerOfEmployeeById(id NUMBER), Package EMPLOYEES
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS.MANAGER_FNAME	Column	View column
NUMBER	PL/SQL System type	PL/SQL System Object
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym