GetAllCustomers

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   CUSTOMERS   >   GetAllCustomers

Procedure body GetAllCustomers(), Package CUSTOMERS

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

Name	Definition
c1	cursor c1 is SELECT ID FROM ALL_CUSTOMERS;

procedure GetAllCustomers
    is
		cursor c1 is
			SELECT ID
			FROM ALL_CUSTOMERS;
    begin
	
	for r1 in c1 loop
        dbms_output.put_line(
            lpad(r1.ID,12)
        );
		end loop;
            

    end GetAllCustomers

Name	Types	Description
<DEFAULT SCHEMA>.ALL_CUSTOMERS	View	View
<DEFAULT SCHEMA>.CUSTOMERS.GetAllCustomers	Procedure	Procedure interface GetAllCustomers(), Package CUSTOMERS
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.ALL_CUSTOMERS.ID	Column	View column
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym

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