title: Oracle SQL - convert select count(*) into zero or one
body: <p>I'm using Oracle and I want to turn the result from a select count into a "binary" 0/1 value ... 0 = 0 ... non-zero = 1.  From what I read online, in MS SQL, you can cast it to a "bit" but Oracle doesn't appear to support that.</p>
  
  <p>Here's my simple example query (the real query is much more complex). I want MATCH_EXISTS to always be 0 or 1. Is this possible?</p>
  
  <pre><code>select count(*) as MATCH_EXISTS 
  from MY_TABLE 
  where MY_COLUMN is not null;
  </code></pre>