title: Foreign Keys and Primary Keys at the same time
body: <p>I am trying to create table (orderdetails2); the table has two FKs and a PKs on the two FK columns.  Here is my code:</p>
  
  <h3>Version 1</h3>
  
  <pre><code>    create table OrderDetails2 (
  PFOrder_ID Number(3)  FOREIGN KEY REFERENCES Orderr(Order_ID),
  PFProduct_ID Number(3) FOREIGN KEY REFERENCES Product(Product_ID),
  CONSTRAINT PF PRIMARY KEY (PFOrder_ID,PFProduct_ID),
  CONSTRAINT FK_1 FOREIGN KEY (PFProudct_ID)
  REFERENCES Product(Product_ID),
  CONSTRAINT FK_2 FOREIGN KEY (PFOrder_ID)
  REFERENCES Orderr(Order_ID),
  </code></pre>
  
  <h3>Version 2</h3>
  
  <pre><code>            create table OrderDetails2 (
      PFOrder_ID Number(3)
      PFProduct_ID Number(3) 
      CONSTRAINT PF PRIMARY KEY (PFOrder_ID,PFProduct_ID),
      CONSTRAINT FK_1 FOREIGN KEY (PFProudct_ID) REFERENCES Product(Product_ID),
      CONSTRAINT FK_2 FOREIGN KEY (PFOrder_ID) REFERENCES Orderr(Order_ID)
  );
  </code></pre>
  
  <p>I am using Oracle express.  A problem pops when I run the code.  Here it is (for version 1): </p>
  
  <pre><code>ORA-00907: missing right parenthesis
  </code></pre>
  
  <p>What is the problem?</p>