Select Insert Long Character PL SQL
DECLARE
CURSOR c IS
SELECT GRP_LVL, DATE, SCORE_FLAG, DESCRLONG
FROM grp_lvl_c1;
rc c%ROWTYPE;
BEGIN
OPEN c;
LOOP
FETCH c INTO rc;
EXIT WHEN c%NOTFOUND;
INSERT INTO grp_lvl_c1
( GRP_LVL, DATE, SCORE_FLAG, DESCRLONG )
VALUES
( rc.GRP_LVL, rc.DATE, rc.SCORE_FLAG, rc.DESCRLONG);
END LOOP;
COMMIT;
END;