oracle判断表是否存在 如果有就删除表.

select table_name  from all_tables where table_name ='LBIPDOCUMENTTYPE';
create or replace procedure super.proc_droptable
is v_tablename varchar2(200);
begin
  select table_name INTO v_tablename from all_tables where table_name ='LBIPDOCUMENTTYPE';
 
   if v_tablename is not null then
    execute immediate 'drop table LBIPDOCUMENTTYPE';
     commit;
   end if;
exception when others then
     commit;
end;

exec super.proc_droptable;

commit;

CREATE TABLE LBIPDOCUMENTTYPE
(
  ID              VARCHAR2(64 BYTE),
  TYPENAME        VARCHAR2(200 BYTE),
  IMAGEPATH       VARCH