title: Update column in oracle in vectorized way
body: <p>I have the following table:</p>
  
  <pre><code>Year Month Day TIME_ID
  
  2018  12  29  (null)
  
  2017  12  21  (null)
  
  ...   ...  ...  ...
  </code></pre>
  
  <p>I want to fill in the column <code>TIME_ID</code> in the following way: <code>select Year||Month||Day from Table</code>. </p>
  
  <p>But I tried the following update statement update TABLE set TIME_ID = (select Year||Month||Day from Table) but it doesn't work because, as I understood, this operation is not vectorized.</p>
  
  <p>Queistion: how can I fill in the TIME_ID column efficiently?</p>