表字段修改备注

select t.TABLE_NAME  表名,
       t.COLUMN_ID   序号,
       t.COLUMN_NAME 字段名,
       t.DATA_TYPE   类型,
       t. DATA_LENGTH      长度,
      decode(t.NULLABLE,'N','PK','')    是否为空,
       b.COMMENTS    注释,
       (case when Trim(t.COLUMN_NAME) in('供应商基本情况表','SPR_NAME','SPR_ENNAME','SPR_ADDR','SPR_TYPE',
         'SPR_LEVEL','SPR_EVA_ORG','SPR_EVA_TIME','SPR_ORGNUM','供应商基本资格等级表',
          'SPR_LIC','SPR_LIC_OFFICE','SPR_REG_AMT','SPR_REG_ADDR',
         'SPR_SCOPE','SPR_SCOPE_SIDE','SPR_TAXNUM','SPR_EARNUM','SPR_TAX_OFFICE','SPR_EAR_OFFICE',
         'SPR_INS','INS_OFFICE','INS_TIMEEND','INS_TIMESTART','INS_FLAG','STAFF_NUM','INS_STAFFNUM',
          'END_STAFFNUM','UNI_STAFFNUM','供应商特定资质证书登记表','SC_NAME','SC_LVL','SC_ORG','VALID_TIMESTART',
          'VALID_TIMEEND','CHKYEAR_FLAG','SC_CONT','供应商出资表','PRO_NAME','PRO_AMT','PRO_PCT','PRO_TIME',
          '供应商分支表','BRC_NAME','BRC_TYPE','BRC_LOCATION','RES_NAME','PES_TEL'
      
       ) then '1' else '0' end  ) changType  
  from user_tab_columns t, USER_COL_COMMENTS B, USER_TAB_COMMENTS C
WHERE t.COLUMN_NAME = B.COLUMN_NAME
   AND t.TABLE_NAME = B.TABLE_NAME
   AND t.TABLE_NAME = C.TABLE_NAME
    
   and t.TABLE_NAME in
       ('SUPPLIER', 'SUPPLIER_QUALIFICATION', 'SUPPLIER_CERTIFICATE',
        'SUPPLIER_FINANCIAL', 'SUPPLIER_PROVIDE', 'SUPPLIER_BRANCH')
   and nvl(b.COMMENTS, ' ') ! = 'delete'