title: Check table exist or not before create it in Oracle
body: <p>Trying to check is table exist before create in Oracle. Search for most of the post from Stackoverflow and others too. Find some query but it didn't work for me.</p>
  
  <pre><code>IF((SELECT count(*) FROM dba_tables where table_name = 'EMPLOYEE') &lt;= 0)
  THEN
  create table EMPLOYEE
  (
  ID NUMBER(3),
  NAME VARCHAR2(30) NOT NULL
  )
  END IF;
  </code></pre>
  
  <p>Which gives me error</p>
  
  <pre><code>Error: ORA-00900: invalid SQL statement
  SQLState:  42000
  ErrorCode: 900
  Position: 1
  </code></pre>
  
  <p>I search for the syntax for <code>IF</code> condition, I think which is also write.
  Please suggest me....</p>