创建表（先判断是否有表）

declare 
      num   number; 
begin 
      select count(1) into num from all_tables where TABLE_NAME =UPPER('CHB_STATISTICS_ATTR'); 
      if   num>0   then 
          execute immediate 'drop table CHB_STATISTICS_ATTR'; 
      end   if; 
end; 
/ 
-- Create table
create table CHB_STATISTICS_ATTR
(
  seqno            VARCHAR2(36) not null,
  statattrcode     VARCHAR2(100) not null,
  assettype        VARCHAR2(100),
  value_expression VARCHAR2(200),
  defaultvalue     VARCHAR2(400),
  effectflag       CHAR(1),
  statattrname     VARCHAR2(100)
);
-- Add comments to the table 
comment on table CHB_STATISTICS_ATTR
  is '中债报送要素资产明细表';
-- Add comments to the columns 
comment on column CHB_STATISTICS_ATTR.seqno
  is '主键';
comment on column CHB_STATISTICS_ATTR.statattrcode
  is '目标元素code';
comment on column CHB_STATISTICS_ATTR.assettype
  is '统计元素类型';
comment on column CHB_STATISTICS_ATTR.value_expression
  is '=CHB_ELEMENT_ATTR表中Attrid计算表达式';
comment on column CHB_STATISTICS_ATTR.defaultvalue
  is '默认值';
comment on column CHB_STATISTICS_ATTR.effectflag
  is '是否有效：E有效、D删除';
comment on column CHB_STATISTICS_ATTR.statattrname
  is '目标元素name';
-- Create/Recreate primary, unique and foreign key constraints 
alter table CHB_STATISTICS_ATTR
  add primary key (SEQNO);