oracle数据库判断表是否存在，存在删除，并创建新表

-判断表是否存在，存在就删除

declare

  v_exists number;

begin

     select count (*) into v_exists from user_tables where table_name = 'LLT_CONSUMERPVSHIELDRECORD' ;

     if v_exists > 0 then

     execute immediate 'drop table LLT_CONSUMERPVSHIELDRECORD' ;

     end if;

        

end ;

/

--创建PV屏蔽值记录表

create table LLT_PVSHIELDRECORD

(

   id              CHAR (32) not null ,

   yearmonth       NUMBER(6),

   psr_id          CHAR (32),

   datatime        DATE ,

   p_originalvalue FLOAT ,

   p_replacevalue  FLOAT ,

   v_originalvalue FLOAT ,

   v_replacevalue  FLOAT

);

-- Add comments to the columns

comment on column LLT_PVSHIELDRECORD.id

   is 'ID' ;

comment on column LLT_PVSHIELDRECORD.yearmonth

   is '所属月份' ;

comment on column LLT_PVSHIELDRECORD.psr_id

   is '设备ID' ;

comment on column LLT_PVSHIELDRECORD.datatime

   is '时间' ;

comment on column LLT_PVSHIELDRECORD.p_originalvalue

   is '有功功率原始值' ;

comment on column LLT_PVSHIELDRECORD.p_replacevalue

   is '有功功率替换值' ;

comment on column LLT_PVSHIELDRECORD.v_originalvalue

   is '电压原始值' ;

comment on column LLT_PVSHIELDRECORD.v_replacevalue

   is '电压替换值' ;

   alter table LLT_PVSHIELDRECORD

   add constraint XPK_LLT_PVSHIELDRECORD primary key (ID);