Oracle 11g: ORA-00907: missing right parenthesis solution

Issue:

When you create table using sql like this.

SQL> create table ships 2 ( 3 ship_id number , 4 ship_name varchar2(20), 5 home_PORT_ID number, 6 constrain ships_ports_fk foreign key (home_port_id) references ports (po t_id) 7 );

You may got following error message after execute.

constrain ships_ports_fk foreign key (home_port_id) references ports (port_id)

*
第 6 行出现错误:
ORA-00907: missing right parenthesis solution

Reason:

You may have something misspell.

Solution:

Please review your sql code to check if anything is misspelled. E.g. In my case, I misspell "constraint" as "constrain".