SQL Error: ORA-00922: missing or invalid option (very confused please help)
664451Oct 9 2008 — edited Oct 17 2008I am trying to create a database table and I receive this error message: SQL Error: ORA-00922: missing or invalid option
here is my code any help would be much appreciated!!!
The other tables customer, supplier, and product all created successfully
CREATE TABLE supship (
sup_ship_id NUMBER(5),
sup_ship_date DATE,
sup_ship_qty NUMBER (20),
sup_ship_unit_price NUMBER(6,2),
cust_address VARCHAR2 (45),
supplier_name VARCHAR2 (8),
prod_sku NUMBER (8),
CONSTRAINT prodship_sup_ship_id_pk PRIMARY KEY (sup_ship_id),
CONSTRAINT prodship_cust_address_fk FOREIGN KEY (cust_address) REFERENCES customer (cust_address)),
CONSTRAINT prodship_supplier_name_fk FOREIGN KEY (supplier_name) REFERENCES supplier (supplier_name)),
CONSTRAINT prodship_prod_sku_fk FOREIGN KEY (prod_sku) REFERENCES product (prod_sku));