title: Create oracle table with auto commit on
body: <p>Here is the scenario,
  I am writing a procedure which performs DML(insert,delete) operations on multiple tables. In case of exception I need to rollback data from most of the tables except one.</p>
  
  <p>Example:</p>
  
  <p>Procedure{</p>
  
  <pre><code>1 Insert into table1
  
  2 Delete from table2
  
  3 Insert into Table3
  
  4 Insert into table4
  
   Commit;
  </code></pre>
  
  <p>Exception</p>
  
  <pre><code>Rollback;
  </code></pre>
  
  <p>}</p>
  
  <p>If there is any exception in 4th Insert, I need to rollback all previous transaction except 3rd one.
  I know, commit/rollback doesn't work like that. But maybe is there way while creating table3, I can set some parameter so that every INSERT statement on table3 will be auto commited.</p>