DECLARE BEGIN
FOR USER IN ( SELECT ID FROM "USER_TABLE" WHERE STATUS = '0' )
loop
BEGIN
INSERT INTO "USER_MENU"
VALUES
( SEQ_USER_MENU.nextval, USER .ID, 30 );
END;
END loop;
commit;
END;
DECLARE BEGIN
FOR USER IN ( SELECT ID FROM "USER_TABLE" WHERE STATUS = '0' )
loop
BEGIN
INSERT INTO "USER_MENU"
VALUES
( SEQ_USER_MENU.nextval, USER .ID, 30 );
END;
END loop;
commit;
END;
本文标题:Oracle循环插入数据脚本
本文链接:https://www.haomeiwen.com/subject/vcinedtx.html
网友评论