Oracle修改表属性添加描述，以及横向合并行数据成列

Oracle

1. 修改表属性，添加描述(例)

ALTER TABLE T_SIGN_CONTRACT ADD (CONTRACT_FLAG VARCHAR2(40));
COMMENT ON COLUMN T_SIGN_CONTRACT.CONTRACT_FLAG IS '合同标志（1-贷款合同2-补货合同）';

2. 横向合并行数据成列属性(例)

select sc.APPLY_ORDER SIGN_APPLY_ORDER ,
        max(decode(ct.TEMPLATE_TYPE,'0',sc.VIEWEWPDF_URL,0)) as VIEWEWPDF_URL,
        max(decode(ct.TEMPLATE_TYPE,'0',sc.DOWNLOAD_URL,0)) as DOWNLOAD_URL,
        max(decode(ct.TEMPLATE_TYPE,'1',sc.VIEWEWPDF_URL,0)) as creditFileUrl,
        max(decode(ct.TEMPLATE_TYPE,'1',sc.DOWNLOAD_URL,0)) as creditFileDownUrl,
        max(decode(ct.TEMPLATE_TYPE,'2',sc.VIEWEWPDF_URL,0)) as loanFileUrl
      from T_SIGN_CONTRACT sc
        left join T_CONTRACT_TEMPLATE ct on ct.TEMPLATE_ID = sc.TEMPLATE_ID
        GROUP BY sc.APPLY_ORDER