|
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
|
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
|