title: How do I check if a sequence exists or not in Oracle 11g?
body: <p>I am using Oracle 11g. I want to be able to determine whether a particular sequence exists or not. I have tried the code below but it is not working. (It is returning 0 as count value when there should be more):</p>
  
  <pre><code>SELECT COUNT(*)
  FROM user_sequences
  WHERE sequence_name = 'SCHEMA.SEQUENCE_NAME';
  </code></pre>
  
  <p>If anyone knows why this is, please help me.</p>