title: Performance increase for an update statement
body: <p>I need to update all the columns in a table using the trimmed version of the same columns. Table has 130 columns and 5 million records. And the query is running more than 3 hours without any sign of completion.</p>
  <pre><code>Begin 
      UPDATE table
         SET column = TRIM(column)
       WHERE date = '01-01-21';
      .
       ..
        ..
      Commit;
  End;
  /
  </code></pre>
  <p>Kindly help in improving the performance of this query.
  PS: none of the columns have any index.</p>