title: FOREIGN KEY ON DELETE RESTRICT Error - Oracle
body: <p>Lately I have been trying to add the following foreign key in the table, with the RESTRICT Clause in Oracle with the following command.:</p>
  
  <pre><code>ALTER TABLE 
  Employee_SalHead 
  ADD CONSTRAINT PAYROLL_SHEAD_FKEY FOREIGN KEY
  (
    SalHead_ID 
  )
  REFERENCES SalHead
  (
    SalHead_ID
  )
  ON DELETE RESTRICT ENABLE;
  </code></pre>
  
  <p>This gave me the following error:</p>
  
  <blockquote>
    <p>Error starting at line : 11 in command - ALTER TABLE  Employee_SalHead ADD
    CONSTRAINT PAYROLL_SHEAD_FKEY FOREIGN KEY (   SalHead_ID )
    REFERENCES SalHead (   SalHead_ID ) ON DELETE RESTRICT ENABLE
    Error report - SQL Error: ORA-00905: missing keyword
    00905. 00000 -  "missing keyword"
    *Cause:<br>
    *Action:</p>
  </blockquote>
  
  <p>Also if I try the same through Oracle SQL developer, I get only the options Set Null, Cascade and No Action Only.</p>