title: How to use Select Exists in Oracle?
body: <p>What is the equivalent of the below <strong><code>SQL Query</code></strong> in <strong><code>Oracle</code></strong>?</p>
  
  <pre><code>SELECT CAST(
     CASE WHEN EXISTS(SELECT * FROM theTable where theColumn like 'theValue%') THEN 1 
     ELSE 0 
     END 
  AS BIT)
  </code></pre>
  
  <p>I just want an oracle query where exists is used and it returns 0 or 1 like above.</p>