Oracel之可重复执行的建表语句

declare 
  v_isExist integer := 0;
begin
  select count(1) into v_isExist from user_tables t where lower(t.table_name) = lower('CAI_DAMO_NOTICE');
  if v_isExist = 0 then
     execute immediate 'create table CAI_DAMO_NOTICE
            (
              NOTICE_ID varchar2(32) NOT NULL,
              NOTICE_TITLE varchar2(64) NOT NULL,
              NOTICE_TYPE varchar2(1) NOT NULL,
              NOTICE_LEVEL varchar2(1) NOT NULL,
              NOTICE_COLONY varchar2(1) NOT NULL,
              NOTICE_BEGDATE DATE,
              NOTICE_ENDDATE DATE,
              NOTICE_FILE_CODE varchar2(16),
              NOTICE_CONTENT clob,
              NOTICE_STATUS varchar2(1),
              PUSH_NOTIFICATION varchar2(1),
              PUBLISH_USER varchar2(16),
              PUBLISH_TIME DATE,
              CREATOR varchar2(16),
              CREATER_TIME DATE,
              OPERATOR varchar2(16),
              OPERATE_TIME DATE
            )tablespace HS_DEMO_DATA';
    execute immediate 'alter table CAI_DEMO_NOTICE add constraint PK_CAI_DEMO_NOTICE_ID primary key (NOTICE_ID) using index tablespace
CAI_DEMO_IDX';
   end if;
     
end;
/

　　注意语句末尾一定要有"/"斜杠