title: Sql, Subquery into a LIKE() operator
body: <p>I'm using oracle 10g and i've a question for you. </p>
  
  <p>Is it possible to "insert" a subquery into a <code>LIKE()</code> operator ?</p>
  
  <p>Exemple : <code>SELECT* FROM users u WHERE u.user_name LIKE ( subquery here );</code> </p>
  
  <p>What i've tried before -></p>
  
  <pre><code>SELECT * FROM dictionary WHERE TABLE_NAME
  LIKE (Select d.TABLE_NAME from dictionary d
        where d.COMMENTS LIKE '%table%'
       )
  WHERE ROWNUM &lt; 100;
  </code></pre>
  
  <p>It tolds me that my query didnt wokrs -> <code>ORA-00933: la commande SQL ne se termine pas correctement</code> (The sql query doesn't finish correctly) and the last <code>WHERE</code> is out.</p>
  
  <p>I know this is a stupid query, but that just a question that i'm looking for an answer =)</p>