title: Query fails with 'ORA-00923: FROM keyword not found where expected'
body: <pre><code>select pl.label_id,
  ( select pv.label_value 
  from PV_I18N_ACTIVE_LOCALE_LABEL pv 
  where pv.locale_id='English' 
  and pv.label_type_id = 'LABEL'
  and pv.label_id = pl.label_id ) as 'English',
  ( select pv.label_value 
  from PV_I18N_ACTIVE_LOCALE_LABEL pv 
  where pv.locale_id='Hindi' 
  and pv.label_type_id = 'LABEL'
  and pv.label_id = pl.label_id ) as 'Hindi',
  
  from PV_I18N_ACTIVE_LOCALE_LABEL pl
  where pl.label_type_id = 'LABEL'
  order by pl.label_id
  </code></pre>
  
  <p>The error is</p>
  
  <pre><code>ORA-00923: FROM keyword not found where expected
  </code></pre>