title: SQL Update all rows for one column with a list of values
body: <p>How can I set all rows of a column by manually typing the values?</p>
  <p>My table has 3 rows, I want the column named <code>mycolumn</code> to have 3 values a, b and c (currently those values are <code>NULL</code>):</p>
  <pre><code>update mytable set mycolumn = ('a','b','c')
  ORA-00907 missing right parenthesis
  </code></pre>
  <p>EDIT: my table is very simple, I have one column <code>ID INT NOT NULL</code> with values 1, 2, 3 and another column <code>mycolumn</code> with all NULL values and I want those values to become <code>'a' where ID = 1</code>, <code>'b' where ID=2</code> etc.</p>
  <p>EDIT2: I might have a huge amount of rows, so I want to avoid typing every single ID value where to replace <code>mycolumn</code>. Isn't it possible to match the ID values of 1 to 3 to the values 'a', 'b', 'c' in an automatic way, something like <code>match(ID, ('a','b','c'))</code> perhaps</p>
  <p><em><strong>I just want to replace all values of <code>mycolumn</code> by increasing order of <code>ID</code>. <code>ID</code> being strictly equivalent to what I call a row number in a matrix</strong></em></p>
  <p>EDIT3: I'd like a solution which would work in a general case with all sorts of values, not only the letters of the alphabet given here for simplicity. What if for example my values to replace in <code>mycolumn</code> are <code>('oefaihfoiashfe', 'fiaohoawdihoiwahopah', 'aefohdfaohdao')</code>? However the <code>ID</code> row numbers will always be a sequence from 1 to N by 1.</p>