title: Remove string before comma in oracle sql developer
body: <p>I have a field which is in this format: </p>
  
  <pre><code>value 1, description
  </code></pre>
  
  <p>What i am trying to do is to update this column by keep only the description part and remove the value 1.</p>
  
  <p>Example of what i have in my field:</p>
  
  <pre><code>1st district, Rockville
  6th district, Gaithersburg / Montgomery Village
  </code></pre>
  
  <p>What i want to have after update:</p>
  
  <pre><code>Rockville
  Gaithersburg / Montgomery Village
  </code></pre>
  
  <p>Now i use this but it gives me the first part instead of second:</p>
  
  <pre><code>SELECT
      (CASE WHEN INSTR(field, ',') &gt; 0
          THEN substr(field, 1, instr(field, ',') +1)
          ELSE myfield
      END) AS myfield
  FROM
      mydata
  </code></pre>