UpdateProductPrice

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   PRODUCTS   >   UpdateProductPrice

Procedure body UpdateProductPrice(productId INTERGER,price NUMBER), Package PRODUCTS

Name	Datatype	Precision	Description
price	number		NUMBER, parameter of PRODUCTS.UpdateProductPrice
productId	interger		INTERGER, parameter of PRODUCTS.UpdateProductPrice

procedure UpdateProductPrice(productId in interger, price in number)
    is
    begin
        UPDATE PRODUCT
			SET unit_price=price
			WHERE id = productId;

    end UpdateProductPrice

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCT	Table	Table
<DEFAULT SCHEMA>.PRODUCTS.UpdateProductPrice	Procedure	Procedure interface UpdateProductPrice(productId INTERGER,price NUMBER), Package PRODUCTS
<DEFAULT SCHEMA>.PRODUCT.UNIT_PRICE	Column	Column
NUMBER	PL/SQL System type	PL/SQL System Object
INTERGER	Undefined Item
<DEFAULT SCHEMA>.PRODUCT.ID	Primary Key	Column