GetProductById | |
|
<DEFAULT SERVER> > <DEFAULT DATABASE> > <DEFAULT SCHEMA> > PRODUCTS > GetProductById |
Procedure body GetProductById(productId NUMBER), Package PRODUCTS
Name | Datatype | Precision | Description |
---|---|---|---|
productId | NUMBER | NUMBER, parameter of PRODUCTS.GetProductById |
Name | Types | Value |
---|---|---|
No Data |
Name | Definition |
---|---|
c1 | cursor c1 is SELECT Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price FROM ALL_Products where id = productId; |
procedure GetProductById( productId in NUMBER )
is
cursor c1 is
SELECT Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price
FROM ALL_Products where id = productId;
begin
null;
end GetProductById
Name | Types | Description |
---|---|---|
<DEFAULT SCHEMA>.ALL_PRODUCTS | View | View |
<DEFAULT SCHEMA>.PRODUCTS.GetProductById | Procedure | Procedure interface GetProductById(productId NUMBER), Package PRODUCTS |
<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 |
NUMBER | PL/SQL System type | PL/SQL System Object |
No Data |
---|