declare 简单用法

判断表中有没有字段（GUID，YEAR，PROVINCE）， 没有的话， 添加字段

declare
T_COUNT NUMBER(4);
SSQL VARCHAR2(2000);
begin 
  SSQL := 'SELECT COUNT(1) FROM user_tab_cols WHERE TABLE_NAME = ''T_PUBINCOMEEXPMANAGE'' AND (COLUMN_NAME = ''GUID'')';
  execute immediate SSQL into T_COUNT;
  if T_COUNT =0 then
     SSQL := 'ALTER TABLE T_PUBINCOMEEXPMANAGE ADD GUID varchar2(32)';
     execute immediate SSQL;            
  end if;

  SSQL := 'SELECT COUNT(1) FROM user_tab_cols WHERE TABLE_NAME = ''T_PUBINCOMEEXPMANAGE'' AND (COLUMN_NAME = ''YEAR'')';
  execute immediate SSQL into T_COUNT;
  if T_COUNT =0 then
     SSQL := 'ALTER TABLE T_PUBINCOMEEXPMANAGE ADD YEAR varchar2(4)';
     execute immediate SSQL;
  end if;

  SSQL := 'SELECT COUNT(1) FROM user_tab_cols WHERE TABLE_NAME = ''T_PUBINCOMEEXPMANAGE'' AND (COLUMN_NAME = ''PROVINCE'')';
  execute immediate SSQL into T_COUNT;
  if T_COUNT =0 then
     SSQL := 'ALTER TABLE T_PUBINCOMEEXPMANAGE ADD PROVINCE varchar2(9)';
     execute immediate SSQL;
  end if;
end;