DB/Oracle(수업)

오라클 12월 14일 숙제

위시 2006. 12. 14. 15:02
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)
);