title: Changing a FK delete rule in Oracle without dropping and recreating it?
body: <p>Is there a way to change a table FK delete rule in Oracle better than dropping and then adding it again?</p>
  
  <p>I'm currently using:</p>
  
  <pre><code>alter table A
  drop constraint my_fk;
  
  alter table A
  add constraint my_fk
  foreign key (id)
  references B(id)
  ON DELETE SET NULL;
  </code></pre>
  
  <p>As you can see, I already have a FK constraint but it had no delete rule on it. I just want to add an ON DELETE SET NULL rule, and that's what I came up with so far, but I'm feeling it should be simpler.</p>