GetAllProducts


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   PRODUCTS   >   GetAllProducts   

Procedure body GetAllProducts(), Package PRODUCTS

No Data
Name Types Value
r1 Variable
Impact Analysis:
Object calling \"r1\" Object Type
<DEFAULT SCHEMA>.PRODUCTS.GetAllProducts Procedure
Name Definition
c1 cursor c1 is SELECT Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price FROM ALL_Products;

procedure GetAllProducts
    is
		cursor c1 is
			SELECT Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price
			FROM ALL_Products;
	
    begin
        for r1 in c1 loop
			dbms_output.put_line(
				lpad(r1.ID,12)
			);
		end loop;
    end GetAllProducts

     
Name Types Description
<DEFAULT SCHEMA>.ALL_PRODUCTS View View
<DEFAULT SCHEMA>.PRODUCTS.GetAllProducts Procedure Procedure interface GetAllProducts(), Package PRODUCTS
LPAD Function PL/SQL System Function
DBMS_OUTPUT.PUT_LINE Function PL/SQL System Function
<DEFAULT SCHEMA>.ALL_PRODUCTS.COLOR Column View column
<DEFAULT SCHEMA>.ALL_PRODUCTS.DESCRIPTION Column View column
<DEFAULT SCHEMA>.ALL_PRODUCTS.ID Column View column
<DEFAULT SCHEMA>.ALL_PRODUCTS.PICTURE_NAME Column View column
<DEFAULT SCHEMA>.ALL_PRODUCTS.PROD_SIZE Column View column
<DEFAULT SCHEMA>.ALL_PRODUCTS.QUANTITY Column View column
<DEFAULT SCHEMA>.ALL_PRODUCTS.TOTAL_HT Column View column
<DEFAULT SCHEMA>.ALL_PRODUCTS.UNIT_PRICE Column View column
PUBLIC.DBMS_OUTPUT Synonym PL/SQL System Synonym

     
No Data