GetAllProducts | |
|
<DEFAULT SERVER> > <DEFAULT DATABASE> > <DEFAULT SCHEMA> > PRODUCTS > GetAllProducts |
Procedure body GetAllProducts(), Package PRODUCTS
No Data |
---|
Name | Types | Value | ||||
---|---|---|---|---|---|---|
r1 | Variable | |||||
Impact Analysis: |
|
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 |
---|