Oracle 跳过具有重复主键或唯一值的行

SQL> create table t (
  2    pk integer not null primary key
  3  );

Table created.

SQL>
SQL> insert into t values (1);

1 row created.

SQL> insert into t values (1);
insert into t values (1)
*
ERROR at line 1:
ORA-00001: unique constraint (CHRIS.SYS_C0019473) violated


SQL> insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX (t (pk)) */ into t values (1);

0 rows created.

SQL>
SQL> insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX (t (pk)) */ into t
  2    select rownum from dual connect by level <= 3;

2 rows created.

SQL>
SQL> select * from t;

        PK
----------
         1
         2
         3