title: Using SQL query to determine if a table exists
body: <p>Guys is there any other way to determine a  table exists other than below</p>
  
  <ol>
  <li><code>select count(*) from &lt;table&gt; where rownum =1</code></li>
  <li><code>select * from user_table where table_name=&lt;table&gt;</code></li>
  </ol>
  
  <p>kindly let me know the best way to check whether a table exists using oracle sql.</p>
  
  <p>Thanks for the answer , my requirement is to check from the first date of current month ie 01/12/2010  with table name in the format suresh_20101201 exists in the database, if not then it should check for table suresh_20101202 and thereon till suresh_20101231 . is it possible to do in oracle sql query.</p>