GetAllEmployees

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   EMPLOYEES   >   GetAllEmployees

Procedure body GetAllEmployees(), Package EMPLOYEES

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

Name	Definition
c1	cursor c1 is SELECT emp_id, emp_lname, emp_fname, emp_street, city,state,zip_code,phone FROM ALL_EMPLOYEES;

procedure GetAllEmployees
    Is 
	--Get All Employees
	 cursor c1 is
			SELECT emp_id, emp_lname, emp_fname, emp_street, city,state,zip_code,phone
			FROM ALL_EMPLOYEES;
			 
    Begin
		


		for r1 in c1 loop
        dbms_output.put_line(
            lpad(r1.emp_id,12) ||
            lpad(r1.emp_id,12) ||
            lpad(r1.emp_id,12)  
        );
		end loop;



    end GetAllEmployees

Name	Types	Description
<DEFAULT SCHEMA>.ALL_EMPLOYEES	View	View
<DEFAULT SCHEMA>.EMPLOYEES.GetAllEmployees	Procedure	Procedure interface GetAllEmployees(), Package EMPLOYEES
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.ALL_EMPLOYEES.CITY	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_FNAME	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_LNAME	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_STREET	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.PHONE	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.STATE	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.ZIP_CODE	Column	View column
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym

Name	Types	Description
<DEFAULT SCHEMA>.DATA.sp_retrieve_employees	Procedure	Procedure body sp_retrieve_employees(), Package DATA