Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Error: ORA-00922: missing or invalid option (very confused please help)

664451Oct 9 2008 — edited Oct 17 2008
I 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));
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2008
Added on Oct 9 2008
2 comments
728 views