title: Remove multiple Trailing Spaces and Update in Columns in Oracle
body: <p>I have an oracle table of M*N Rows and columns  which has multiple trailing spaces. </p>
  
  <p>I'm using the below two statements to find the trailing space and update the value. I'm Looking for a script that will work on a table,  don't know how many columns the table has, the names of those columns, and which of them are of  data type varchar, etc.</p>
  
  <pre><code>Select * From Table Where Column_Name&lt;&gt; TRIM(Column_Name);
  
  UPDATE Table 
  set Column_Name= trim(Column_Name)
  where Condition=;
  commit;
  </code></pre>
  
  <p>Is there a script where I can update the whole table which has Multiple trailing spaces in one go?</p>
  
  <pre><code>M*N     |Columns|   |   |
  ------------------------------------
  Rows    |Trail  |   |   |
  ------------------------------------
          |Trail  |   |   |
  ------------------------------------
          |   |   |   |
  ------------------------------------
          |   |   |Trail  |
  ------------------------------------
          |   |Trail  |   |
  ------------------------------------
          |   |   |   |
  ------------------------------------
          |   |   |   |
  ------------------------------------
          |Trail  |   |   |
  ------------------------------------
  </code></pre>