Oracle 18c

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

CREATE TABLE your_codes_table ( value ) AS
SELECT DBMS_RANDOM.STRING( 'A', 10 ) FROM DUAL CONNECT BY LEVEL <= 10;
10 rows affected

CREATE SEQUENCE destination_table__id__seq;
CREATE TABLE destination_table (id, code) AS
SELECT destination_table__id__seq.NEXTVAL,
       CAST( NULL AS VARCHAR2(10) )
FROM   DUAL
CONNECT BY LEVEL <= 8;
8 rows affected

SELECT * FROM destination_table;


ID
CODE


1
null

2
null

3
null

4
null

5
null

6
null

7
null

8
null


MERGE INTO destination_table dst
USING (
  SELECT ROWNUM rn,
         value
  FROM   your_codes_table
) src
ON ( src.rn = dst.id )
WHEN MATCHED THEN
  UPDATE SET code = src.value
WHEN NOT MATCHED THEN
  INSERT ( id, code ) VALUES ( destination_table__id__seq.NEXTVAL, src.value );
10 rows affected

SELECT * FROM destination_table;


ID
CODE


1
OmUwlOKBYD

2
oYWNKWYARh

3
nHCVPvaWbM

4
vfiYdwoqFS

5
jrvQykFJRy

6
NoUzfFzSNz

7
vOIbqLOcJy

8
kPCCstLmLe

17
EYAyEvHioC

18
qZaOSVmlmN


DELETE FROM destination_table;
10 rows affected

DROP SEQUENCE destination_table__id__seq;
CREATE SEQUENCE destination_table__id__seq;
INSERT INTO destination_table ( id, code )
SELECT destination_table__id__seq.NEXTVAL,
       value
FROM   your_codes_table
10 rows affected

SELECT * FROM destination_table;


ID
CODE


1
OmUwlOKBYD

2
oYWNKWYARh

3
nHCVPvaWbM

4
vfiYdwoqFS

5
jrvQykFJRy

6
NoUzfFzSNz

7
vOIbqLOcJy

8
kPCCstLmLe

9
EYAyEvHioC

10
qZaOSVmlmN


MERGE INTO destination_table dst
USING (
  SELECT ROWNUM rn,
         value
  FROM   your_codes_table
) src
ON ( src.rn = dst.id )
WHEN MATCHED THEN
  UPDATE SET code = src.value
WHEN NOT MATCHED THEN
  INSERT ( id, code ) VALUES ( destination_table__id__seq.NEXTVAL, src.value );
10 rows affected

ID	CODE
1	null
2	null
3	null
4	null
5	null
6	null
7	null
8	null

ID	CODE
1	OmUwlOKBYD
2	oYWNKWYARh
3	nHCVPvaWbM
4	vfiYdwoqFS
5	jrvQykFJRy
6	NoUzfFzSNz
7	vOIbqLOcJy
8	kPCCstLmLe
17	EYAyEvHioC
18	qZaOSVmlmN