ORACLE 为表添加字段,没有添加,有就跳过
发布时间:2020-12-12 15:49:48 所属栏目:百科 来源:网络整理
导读:DECLAREv_sql VARCHAR2(200);v_table VARCHAR2(30);v_clums NUMBER;CURSOR C1 IS SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE 'UE_GW_%';BEGINOPEN C1;LOOPFETCH C1 INTO v_table;select count(column_name) INTO v_clums from user_tab_colu
DECLARE v_sql VARCHAR2(200); v_table VARCHAR2(30); v_clums NUMBER; CURSOR C1 IS SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE 'UE_GW_%'; BEGIN OPEN C1; LOOP FETCH C1 INTO v_table; select count(column_name) INTO v_clums from user_tab_columns where table_name= v_table AND COLUMN_NAME = 'HZZSY'; IF v_clums = 0 THEN v_sql:='ALTER TABLE '||v_table||' ADD HZZSY VARCHAR2(50)'; EXECUTE IMMEDIATE v_sql; END IF; END LOOP; CLOSE C1; END; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |