title: creating table in sql developer with primary and foreign keys
body: <p>I'm trying to create a table with primary and foreign keys using following syntax for sql developer but it is not working.</p>
  
  <p>Can anyone see where I am going wrong?</p>
  
  <pre><code>CREATE Athlete
  (
      ATHLETEID CHAR(4) NOT NULL,
      ATHLETEFIRSTNAME VARCHAR2(20),
      ATHLETELASTNAME VARCHAR2(20),
      ATHLETEDOB DATE,
      REPCOUNTRY VARCHAR2(12),
      COACHID CHAR(4) NOT NULL,
  
      CONSTRAINT ATHLETE_PK PRIMARY KEY (ATHLETEID),
      CONSTRAINT ATHLETE_FK FOREIGN KEY (COACHID) REFERENCES COACH(COACHID) 
  
  );
  </code></pre>