【Oracle】表追加字段

/**   
 *  描述：帮扶对象追加字段脚本
 */
DECLARE
    num1 NUMBER;
    num2 NUMBER;
BEGIN
    SELECT COUNT(1) INTO num1 FROM cols
        WHERE table_name = upper('T_ZZ_SUPPORT_OBJECT')
        AND column_name = upper('creator_id');

    SELECT COUNT(1) INTO num2 FROM cols
        WHERE table_name = upper('T_ZZ_SUPPORT_OBJECT')
        AND column_name = upper('create_time');

    IF num1 < 1 THEN
        execute immediate 'alter table T_ZZ_SUPPORT_OBJECT add creator_id NUMBER(9)';
    END IF;

    IF num2 < 1 THEN
        execute immediate 'alter table T_ZZ_SUPPORT_OBJECT add create_time DATE';
    END IF;
END;
/
COMMIT;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!