CreateProduct


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   PRODUCTS   >   CreateProduct   

Procedure body CreateProduct(name NVARCHAR2,description NVARCHAR2,prod_size INTEGER,quantity NUMBER,unit_price NUMBER), Package PRODUCTS

Name Datatype Precision Description
description nvarchar2 NVARCHAR2, parameter of PRODUCTS.CreateProduct
name nvarchar2 NVARCHAR2, parameter of PRODUCTS.CreateProduct
prod_size integer INTEGER, parameter of PRODUCTS.CreateProduct
quantity number NUMBER, parameter of PRODUCTS.CreateProduct
unit_price number NUMBER, parameter of PRODUCTS.CreateProduct
Name Types Value
No Data
Name Definition
No Data

procedure CreateProduct(name in nvarchar2, description in nvarchar2, prod_size in integer, quantity in number, unit_price in number)
    is
    begin
	
		INSERT INTO PRODUCT (name, description,prod_size,quantity,unit_price) VALUES (name, description,prod_size,quantity,unit_price);
           
    end CreateProduct

     
Name Types Description
<DEFAULT SCHEMA>.PRODUCT Table Table
<DEFAULT SCHEMA>.PRODUCTS.CreateProduct Procedure Procedure interface CreateProduct(name NVARCHAR2,description NVARCHAR2,prod_size INTEGER,quantity NUMBER,unit_price NUMBER), Package PRODUCTS
<DEFAULT SCHEMA>.PRODUCT.UNIT_PRICE Column Column
INTEGER PL/SQL System type PL/SQL System Object
NUMBER PL/SQL System type PL/SQL System Object
NVARCHAR2 PL/SQL System type PL/SQL System Object

     
No Data