Oracle_J_添加字段

DECLARE
   I   INTEGER;
BEGIN
   SELECT COUNT (*)
     INTO I
     FROM COLS
    WHERE     TABLE_NAME = UPPER ('LIS_BARCODEMAIN_ARCHIVED')
          AND COLUMN_NAME = UPPER ('GREENPERSONMENO');

   IF I = 0
   THEN
      EXECUTE IMMEDIATE
         'ALTER TABLE ZYLIS.LIS_BARCODEMAIN_ARCHIVED ADD(GREENPERSONMENO varchar2(200))';
   END IF;
END;

COMMENT ON COLUMN ZYLIS.LIS_BARCODEMAIN_ARCHIVED.GREENPERSONMENO IS '备注';

COMMIT;