title: Oracle Create TABLE
body: <p>I am trying to create a table with foreign key using oracle. My syntax is as follows</p>
  
  <pre><code>CREATE TABLE product (
     product_id       INT(7) NOT NULL,
     supplier_id      INT(7) NOT NULL,
     product_name     VARCHAR2(30),
     product_price    DOUBLE(4),
     product_category VARCHAR2(30),
     product_brand    VARCHAR2(20),
     product_expire   DATE,
     PRIMARY KEY (product_id),
     FOREIGN KEY (supplier_id)
  )
  </code></pre>
  
  <p>I got a error, saying </p>
  
  <blockquote>
    <p>Error at Command Line:2 Column:14 Error report: SQL Error: ORA-00907:
    missing right parenthesis
    00907. 00000 -  "missing right parenthesis"
    *Cause:<br>
    *Action:</p>
  </blockquote>
  
  <p>Please help!</p>