I'm new to Oracle. I'm trying to create a table with a foreign key, but I keep getting the cryptic error message:
ORA-00907: missing right parenthesis
for:
CREATE TABLE purchase_history
(
PURCHASE_NUMBER VARCHAR(16) NOT NULL,
CREDIT_ENABLED CHAR(1) NOT NULL CHECK (CREDIT_ENABLED IN ('T','F')),
CONSTRAINT fk_customers FORIEGN KEY (customer_id) REFERENCES customers(customer_id)
);
I'm not seeing the missing parenthesis. I'm guessing something else is going on. I've Googled around on examples for creating tables with foreign keys. I found a couple of different styles for syntax and tried a few with no joy.
How do I need to change my statement above?
Thanks much
Steve