首页 > 其他 > 详细

ORCALE 增加两列字段

时间:2017-04-28 10:04:24      阅读:181      评论:0      收藏:0      [点我收藏+]


declare v_cnt number;
 V_SQL VARCHAR2 (500) := ‘‘;
begin
 select count(*) into v_cnt from dual where exists(SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME = UPPER(‘TB_FDN_DEVICEACCOUNT‘) AND COLUMN_NAME = ‘NSBFL‘);
   if v_cnt = 0 then
    V_SQL := ‘ALTER TABLE TB_FDN_DEVICEACCOUNT ADD NSBFL NVARCHAR2(50)‘;
    EXECUTE IMMEDIATE V_SQL;
    V_SQL := ‘comment on column TB_FDN_DEVICEACCOUNT.NSBFL is ‘‘原设备分类‘‘‘;
    EXECUTE IMMEDIATE V_SQL;
end if;
 select count(*) into v_cnt from dual where exists(SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME = UPPER(‘TB_FDN_DEVICEACCOUNT‘) AND COLUMN_NAME = ‘NSBLX‘);
   if v_cnt = 0 then
    V_SQL := ‘ALTER TABLE TB_FDN_DEVICEACCOUNT ADD NSBLX NVARCHAR2(50)‘;
    EXECUTE IMMEDIATE V_SQL;
    V_SQL := ‘comment on column TB_FDN_DEVICEACCOUNT.NSBLX is ‘‘原设备类型‘‘‘;
    EXECUTE IMMEDIATE V_SQL;
end if;
end;

ORCALE 增加两列字段

原文:http://www.cnblogs.com/daimaxuejia/p/6780125.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!