title: How to run one update and commit in single command in ORACLE
body: <p>I want to run a update query in ORACLE but to reflect the change of that query (means updating the value in database with receptive values) i have to run a <strong>commit;</strong> after that query (then only the value change will be updated in the database). So, how can i pass the update statement and the commit in same line through C#. </p>
  
  <p>i am running the query like below,</p>
  
  <pre><code>UPDATE table_name 
     SET columnname1 = 'N', 
         columnname2 = 1
   WHERE columnname3 = '-2085371064';
  
  COMMIT;
  </code></pre>