title: ORA-00923 FROM keyword not found where expected
body: <p>I am trying to concatenate some fields to return a single string for each row from an oracle table.  This is in 10g.  Here is my query:</p>
  
  <pre><code>SELECT t.value || '|' || t.label || '|' t.label_abbrv || '||' "mylist" 
    FROM list_value t
   WHERE t.value BETWEEN 195001 AND 195300;
  </code></pre>
  
  <p>I'm getting the "FROM keyword not found where expected" error.  This is really annoying.  It's a simple query.  I'm sure it's something simple I'm missing.</p>