oracle判断数据是否存在吗_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);