declare 执行报错

[zpworld]

declare a NUMBER;
BEGIN
select count(1) into a from user_tables where table_name='F_Material_QUALITY_EXAMINATION';
if a>0 then
dbms_output.put_line('F_Material_QUALITY_EXAMINATION表存在');
else
dbms_output.put_line('F_Material_QUALITY_EXAMINATION表不存在');
EXECUTE IMMEDIATE '
create table "F_Material_QUALITY_EXAMINATION"
(
QUALITY_N_ID VARCHAR2(32) not null,
SUPPLIER_CODE VARCHAR2(32),
BRAND_CODE VARCHAR2(32),
PRODUCT_DEPARTMENT_CODE VARCHAR2(32),
REPORT_DATE_CODE VARCHAR2(8),
GJZJL VARCHAR2(255),
SGZBX VARCHAR2(255),
GYSGJX VARCHAR2(255),
QUALIFIED_PERCENT NUMBER(14,2),
UNQUALIFIED_PERCENT NUMBER(14,2),
COMPROMISE_PERCENT NUMBER(14,2),
CHECKOUT_RESULT VARCHAR2(255),
constraint PK_F_MATERIAL_QUALITY_EXAMINAT primary key (QUALITY_N_ID)
)
partition by range (partition
P2010
values less than (20100401-20110331))';
EXECUTE IMMEDIATE '
comment on table "F_Material_QUALITY_EXAMINATION" is
''sdf ''';
EXECUTE IMMEDIATE '
comment on column "F_Material_QUALITY_EXAMINATION".SUPPLIER_CODE is
''sdfsf''';

END if;
END;
/


ORA-00907: 缺失右括号
ORA-06512: 在 line 8
麻烦大家看看谢谢

[liyongjie]

创建分区表的语法有误啊
declare
a NUMBER;
BEGIN
select count(1)
into a
from user_tables
where table_name = 'F_Material_QUALITY_EXAMINATION';
if a > 0 then
dbms_output.put_line('F_Material_QUALITY_EXAMINATION表存在');
else
dbms_output.put_line('F_Material_QUALITY_EXAMINATION表不存在');
EXECUTE IMMEDIATE '
create table "F_Material_QUALITY_EXAMINATION"
(
QUALITY_N_ID VARCHAR2(32) not null,
SUPPLIER_CODE VARCHAR2(32),
BRAND_CODE VARCHAR2(32),
PRODUCT_DEPARTMENT_CODE VARCHAR2(32),
REPORT_DATE_CODE VARCHAR2(8),
GJZJL VARCHAR2(255),
SGZBX VARCHAR2(255),
GYSGJX VARCHAR2(255),
QUALIFIED_PERCENT NUMBER(14,2),
UNQUALIFIED_PERCENT NUMBER(14,2),
COMPROMISE_PERCENT NUMBER(14,2),
CHECKOUT_RESULT VARCHAR2(255),
constraint PK_F_MATERIAL_QUALITY_EXAMINAT primary key (QUALITY_N_ID)
)
partition by range(QUALITY_N_ID)(
partition P2010
values less than (''20100401-20110331'')
)';
EXECUTE IMMEDIATE '
comment on table "F_Material_QUALITY_EXAMINATION" is
''sdf ''';
EXECUTE IMMEDIATE '
comment on column "F_Material_QUALITY_EXAMINATION".SUPPLIER_CODE is
''sdfsf''';

END if;
END;