17,086
社区成员
发帖
与我相关
我的任务
分享
改为:
DECLARE
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE TEMP(ID NUMBER)';
FOR I IN 0 .. 10 LOOP
IF (I = 5 OR I = 6 OR I = 7) THEN
NULL;
ELSE
EXECUTE IMMEDIATE 'INSERT INTO TEMP VALUES(:1)'
USING I; COMMIT;
END IF;
END LOOP;
END;