title: oracle - what statements need to be committed?
body: <p>What are the list of statements that need to be committed before further action on the table in order to avoid a lock? I am not talking about full transactions with multiple statements and transaction integrity; instead I am referring to single statements.</p>
  
  <p>I know insert should be committed but truncate has an autocommit. What is the full list of statements that need to be committed?</p>
  
  <p>Need to be committed (starter list):</p>
  
  <pre><code>UPDATE
  INSERT
  DELETE
  </code></pre>