Oracle一次给多个表添加相同字段

categories:

• 日常记录
  tags:
• 数据库

---可以选择多张表，也可以直接更新所有
SELECT TABLE_NAME FROM USER_TABLES where table_name in ('T_USER','T_INFO');
----------------------------------------------------------------------------
DECLARE 
  CURSOR C4 IS SELECT TABLE_NAME FROM USER_TABLES where table_name in ('T_USER');
  v_SQL VARCHAR(2000);
  V_TABLE_NAME VARCHAR(3000);
  
BEGIN
  OPEN C4;
  LOOP
  FETCH C4
  INTO V_TABLE_NAME;
  EXIT WHEN C4%NOTFOUND;
  V_SQL := 'ALTER TABLE ' || V_TABLE_NAME || ' ADD TEST7 VARCHAR(100)';
  EXECUTE IMMEDIATE V_SQL;
  END LOOP;
  CLOSE C4;
END;