Hi, can any one explain me what function of this for loop and the 'execute immediate command line' . C_ALTER_INDEXES is a cursor
FOR L_ALTER_INDEXES IN C_ALTER_INDEXES
LOOP
DBMS_OUTPUT.PUT _LINE(L_ALTER_I NDEXES.INDEX_AL TER);
EXECUTE IMMEDIATE L_ALTER_INDEXES .INDEX_ALTER;
END LOOP;
FOR L_ALTER_INDEXES IN C_ALTER_INDEXES
LOOP
DBMS_OUTPUT.PUT _LINE(L_ALTER_I NDEXES.INDEX_AL TER);
EXECUTE IMMEDIATE L_ALTER_INDEXES .INDEX_ALTER;
END LOOP;
Comment