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