Oracle 18c

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

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table t1( id integer  
               , val varchar2(20) 
               ); 
create table t2( id integer 
               , val varchar2(20) 
               ); 
insert into t1(id, val)
   select level, 'item-' || to_char(level,'fm009')
     from dual connect by level <= 20; 
20 rows affected

select * from t1;


ID
VAL


1
item-001

2
item-002

3
item-003

4
item-004

5
item-005

6
item-006

7
item-007

8
item-008

9
item-009

10
item-010

11
item-011

12
item-012

13
item-013

14
item-014

15
item-015

16
item-016

17
item-017

18
item-018

19
item-019

20
item-020


-- copy some rows from table t1 into table t2
insert into t2(id, val) 
   select id, val 
     from t1 
    where id in (select trunc(dbms_random.value(1,20))   
                   from dual connect by level <= 10
                ) ;
10 rows affected

select * from t2;


ID
VAL


1
item-001

3
item-003

6
item-006

8
item-008

10
item-010

12
item-012

13
item-013

14
item-014

16
item-016

19
item-019


 -- which rows were not copied
 select id from t1
 MINUS
 select id from t2; 


ID


2

4

5

7

9

11

15

17

18

20

ID	VAL
1	item-001
2	item-002
3	item-003
4	item-004
5	item-005
6	item-006
7	item-007
8	item-008
9	item-009
10	item-010
11	item-011
12	item-012
13	item-013
14	item-014
15	item-015
16	item-016
17	item-017
18	item-018
19	item-019
20	item-020