title: Creating a foreign key constraint with Oracle
body: <p>I'm trying to create a constraint between table mail.id to table disposition.mailid, here is my syntax </p>
  
  <pre><code>alter table disposition add foreign key (mailid) references mail(id) on cascade delete;
  </code></pre>
  
  <p>the problem is I get this error </p>
  
  <pre><code>alter table disposition add foreign key (mailid) references mail(id) on cascade delete
  ORA-00905: missing keyword
  
  Time: 0,002s
  </code></pre>
  
  <p>or is there any easy way to make a constraint between two table on navicat?</p>