oracle的drop table if exists____oracle

利用儲存實現 

create or replace procedure proc_dropifexists(     p_table in varchar2 ) is     v_count number(10); begin    select count(*)    into v_count    from user_tables    where table_name = upper(p_table);    if v_count > 0 then       execute immediate 'drop table ' || p_table ||' purge';    end if; end proc_dropifexists; exec proc_dropifexists('d_product'); CREATE TABLE d_product (   id number(12)  primary key,   product_name varchar(100) NOT NULL,   description varchar(100) default NULL,   add_time number(20) default NULL,   fixed_price number(38) NOT NULL,   dang_price number(38) NOT NULL,   keywords varchar(200) default NULL,   has_deleted integer default '0' NOT NULL ,   product_pic varchar(200) default NULL   ) ;