title: How to resolve ORA 00936 Missing Expression Error?
body: <pre><code>Select /*+USE_HASH( a b ) */ to_char(date, 'MM/DD/YYYY HH24:MI:SS') as LABEL,
  ltrim(rtrim(substr(oled, 9, 16))) as VALUE,
  from rrfh a, rrf b,
  where ltrim(rtrim(substr(oled, 1, 9))) = 'stata kish' 
  and a.xyz = b.xyz 
  </code></pre>
  
  <p>The "from " (3rd line) part of the above query is giving me <code>ORA-00936 Missing EXPRESSION error</code>. Please Help me </p>
  
  <p><strong>NOTE</strong> :: rrfh table contains no data.</p>