ignore_row_on_dupkey_index_test

View All Public Scripts Login to Run Script

Statement 1

CREATE TABLE tbl( 
  tbl_no NUMBER(10) UNIQUE 
)

Table created.

Statement 2

CREATE TABLE tbl_tmp( 
  tbl_no NUMBER(10) 
)

Table created.

Statement 3

INSERT INTO tbl_tmp VALUES(1)

1 row(s) inserted.

Statement 4

INSERT INTO tbl_tmp VALUES(1)

1 row(s) inserted.

Statement 5

INSERT INTO tbl_tmp VALUES(2)

1 row(s) inserted.

Statement 6

INSERT /*+ ignore_row_on_dupkey_index(tbl(tbl_no)) */ 
INTO tbl( 
  tbl_no 
) 
SELECT 
  tbl_no 
FROM tbl_tmp

2 row(s) inserted.

Statement 7

SELECT * FROM tbl


TBL_NO
1
2

2 rows selected.

TBL_NO
1
2

Additional Information