create table reporttable
(
ord_id number(7) constraints s_item_ordid_prodid_uk unique not null,
item_id number(7) constraints s_item_ordid_itemid_pk primary key not null,
product_id number(7) not null,
price number(11, 2),
quantity number(9),
quantity_shipped number(9)
);
AND