declare

  cnt number;

begin

select count(*) into cnt from user_tab_columns where TABLE_NAME ='TWORKFLOWLIST' and COLUMN_NAME='C_STATUS' and data_length < 2;  

 if cnt<=0 then

execute immediate 'alter table TWORKFLOWLIST modify (C_STATUS varchar2(2))';

execute immediate 'comment on column TWORKFLOWLIST.C_STATUS

   is ''工作报告状态(new),新增字典"工作报告状态" 0 草稿,1,已提交,2已通过3已驳回，4已汇总；5未发布(用于客服日报)，6已发布(用于客服日报)；20计划草稿,21计划提交,10总结草稿,11总结提交''';

    end if;

end;

/