title: VARCHAR in Oracle DB
body: <p>I have this query that runs in SQL Server:</p>
  <pre><code>SELECT 
      COUNT(T.Texte) 
  FROM
      (SELECT 
           CONVERT(varchar(8000), CONVERT(binary(8000), USER_DATA)) AS Texte 
       FROM 
           O_USER_DATA ) T
  WHERE
      T.Texte LIKE '%test123%'
  </code></pre>
  <p>In Oracle it doesn't compile. I get an exception:</p>
  <blockquote>
  <p>missing expression</p>
  </blockquote>
  <p>How to modify my query so it will run in an Oracle database?</p>