PL/SQL error ORA-00907

[stormking]

Hi,

I am just starting tolearn Oracle PL/SQL and am getting an error right off the bat that I can't seem to get rid of, here it is:
CREATE TABLE book_copies (
barcode_id VARCHAR2(100) NOT NULL PRIMARY KEY,
isbn VARCHAR2(13) FOREIGN KEY REFERENCES books (isbn)
);

error at line 3:
ORA-00907: missing right parenthesis

I have tried to add another parenthesis, closing spaces and several other things, but it still gives me errors.

I appreciate any help

Thanks

Wendy

 

[umeman]

Try the following :
CREATE TABLE book_copies (
barcode_id VARCHAR2(100) NOT NULL PRIMARY KEY,
isbn VARCHAR2(13),
constraint books_fk FOREIGN KEY (isbn) REFERENCES books
)

 

[Guest_imported]

Just remove the "FOREIGN KEY" from your statement. (Assumed that you already have a table called books.)

When you 'create' a table you don't specify FOREIGN KEY, but
you do if you use 'alter' option.

The Following code will work.

CREATE TABLE book_copies (
barcode_id VARCHAR2(100) NOT NULL PRIMARY KEY,
isbn VARCHAR2(13) REFERENCES books (isbn)
) ;

 

[stormking]

Thanks umeman

It worked, I will store this away for use in the future.

Thanks again. I am sure you'll be seeing me a lot while learning PL/SQL.

Thanks again.

Stormking