title: PL/SQL if table not exist create
body: <p>Hello i use oracle SQL developer</p>
  
  <p>I have create a procedure, and i need to check if a table exist, if not exist i must create how can do?</p>
  
  <p>I have try this</p>
  
  <pre><code>DECLARE v_emp int:=0;
  BEGIN
    SELECT count(*) into v_emp FROM dba_tables; 
  
    if v_emp = 0 then
       EXECUTE IMMEDIATE 'create table EMPLOYEE ( ID NUMBER(3), NAME VARCHAR2(30) NOT NULL)';
    end if;
  END;
  </code></pre>
  
  <p>but give me an error 00103 because not find table</p>