Oracle循环插入数据脚本
2023-06-07 本文已影响0人
_借东西的小人
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;
