Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE MAILS (VAL NUMBER);
BEGIN
  FOR n IN 1..10 LOOP
    IF n NOT IN (6,8) THEN
      insert into mails
      VALUES (n);
    END IF;
  END LOOP;

  commit;
END;
/
1 rows affected

SELECT * FROM MAILS;

VAL

1

2

3

4

5

7

9

10

TRUNCATE TABLE MAILS;
INSERT INTO MAILS
  SELECT LEVEL
    FROM DUAL
    WHERE LEVEL NOT IN (6,8)
    CONNECT BY LEVEL <= 10
8 rows affected

SELECT * FROM MAILS;

VAL

1

2

3

4

5

7

9

10

TRUNCATE TABLE MAILS;
MERGE INTO MAILS m
  USING (SELECT LEVEL AS N
           FROM DUAL
           WHERE LEVEL NOT IN (6,8)
           CONNECT BY LEVEL <= 10) d
    ON (m.VAL = d.N)
  WHEN NOT MATCHED THEN
    INSERT VALUES (N);
8 rows affected

SELECT * FROM MAILS;

VAL

5

3

1

2

10

7

4

9