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 customers (customer number(2));
insert into customers
select 1 from dual union all select 2 from dual union all select 3 from dual union all 
select 4 from dual union all select 5 from dual union all select 6 from dual union all 
select 7 from dual union all select 8 from dual union all select 9 from dual;
9 rows affected

create table employees (employee varchar2(1));
insert into employees
select 'A' from dual union all select 'B' from dual union all select 'C' from dual;
3 rows affected

with e as
(
  select employee, row_number() over (order by employee) as rn
  from employees
)
, c as
(
  select customer, row_number() over (order by customer) as rn
  from customers
)
select c.customer, e.employee
from c
join e on e.rn - 1 = mod(c.rn - 1, (select count(*) from e))
order by c.customer;


CUSTOMER
EMPLOYEE


1
A

2
B

3
C

4
A

5
B

6
C

7
A

8
B

9
C