oracle分表添加表字段

--批量增加分表字段脚本

DECLARE

    V_SQL VARCHAR2(2000);

    V_TABLE_NAME VARCHAR2(100);

CURSOR C1 IS

    SELECT TABLE_NAME FROM USER_TABLES where TABLE_NAME like 'department%'; --查询当前用户下的所有的分表

BEGIN

    OPEN C1;

        LOOP

            --提取一行数据到c1

            FETCH C1

            INTO V_TABLE_NAME;

            --判读是否提取到值，没取到值就退出

            EXIT WHEN C1%NOTFOUND;

            V_SQL := 'alter table ' || V_TABLE_NAME || ' add user_name varchar2(32)';

            EXECUTE IMMEDIATE V_SQL;

        END LOOP; --关闭游标

    CLOSE C1;

END;