title: ORA-00907: missing right parenthesis Error while creating a table?
body: <p>I am new to oracle,
  I have created two tables using following queries,</p>
  
  <pre><code>CREATE TABLE employee
  (
   emp_name VARCHAR(20) NOT NULL,
   street VARCHAR(50) NOT NULL,
   city VARCHAR(20) NOT NULL,
   PRIMARY KEY(emp_name)
  )
  </code></pre>
  
  <p>and </p>
  
  <pre><code>CREATE TABLE company
  (
   comp_name VARCHAR(20) NOT NULL,
   city VARCHAR(20) NOT NULL,
   PRIMARY KEY(comp_name)
  )
  </code></pre>
  
  <p>Now I am trying to create another table using some foreign keys,</p>
  
  <pre><code>CREATE TABLE works
  (
  emp_name varchar(20) NOT NULL,
  comp_name varchar(20) NOT NULL,
  salary  int(10) NOT NULL,
  FOREIGN KEY(emp_name) REFERENCES employee(emp_name),
  FOREIGN KEY(comp_name) REFERENCES company(comp_name)
  )
  </code></pre>
  
  <p>Getting ERROR : ORA-00907: missing right parenthesis</p>
  
  <p>I have also tried with</p>
  
  <pre><code>CREATE TABLE works
  (
  emp_name varchar(20) NOT NULL,
  comp_name varchar(20) NOT NULL,
  salary  int(10) NOT NULL,
  constraint wemployee FOREIGN KEY(emp_name) REFERENCES employee(emp_name),
  constraint wcompany FOREIGN KEY(comp_name) REFERENCES company(comp_name)
  )
  </code></pre>
  
  <p>But getting same error.
  Can any one tell me that where I am doing mistake?</p>