title: Set Foreign Key Check OFF
body: <p>I tried to use this..</p>
  
  <pre><code>SQL&gt; SET FOREIGN_KEY_CHECKS = 0;
  SP2-0735: unknown SET option beginning "FOREIGN_KE..."
  </code></pre>
  
  <p>But it say unknown set option</p>
  
  <p>I am using oracle sql 11g express e</p>
  
  <p>I also tried</p>
  
  <pre><code>begin
  for i in (select constraint_name, table_name from user_constraints where constraint_type ='R'
  and status = 'ENABLED') LOOP
  execute immediate 'alter table '||i.table_name||' disable constraint '||i.constraint_name||'';
  end loop;
  end;
  </code></pre>
  
  <p>But the console stuck at line 7, not executing or something..</p>
  
  <p>Heres what happen..</p>
  
  <p>Connected.</p>
  
  <pre><code>SQL&gt; begin
    2  for i in (select constraint_name, table_name from user_constraints where co
  nstraint_type ='R'
    3  and status = 'ENABLED') LOOP
    4  execute immediate 'alter table '||i.table_name||' disable constraint '||i.c
  onstraint_name||'';
    5  end loop;
    6  end;
    7
  </code></pre>
  
  <p>It show the 7 then no longer work</p>