Oracle 11g Release 2

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

CREATE TABLE Students
    ("NAME" varchar2(6))
;

INSERT ALL 
    INTO Students ("NAME")
         VALUES ('Adam')
    INTO Students ("NAME")
         VALUES ('Bennet')
    INTO Students ("NAME")
         VALUES ('Elmer')
    INTO Students ("NAME")
         VALUES ('Justin')
    INTO Students ("NAME")
         VALUES ('Louis')
    INTO Students ("NAME")
         VALUES ('Noah')
    INTO Students ("NAME")
         VALUES ('Jack')
SELECT * FROM dual
;
7 rows affected

CREATE TABLE Teachers
    ("NAME" varchar2(5))
;

INSERT ALL 
    INTO Teachers ("NAME")
         VALUES ('Leo')
    INTO Teachers ("NAME")
         VALUES ('Kyle')
    INTO Teachers ("NAME")
         VALUES ('Ethan')
SELECT * FROM dual
;
3 rows affected

with tch as
(
 select t.*, row_number() OVER ( ORDER BY name ) as n from teachers t
 ),
ct AS
 ( 
  select count(*) as cnt from Teachers
  )
 select s.name,tch.name from
 (

     SELECT name, NTILE(cnt) OVER (partition by cnt ORDER BY name)  AS n 
         FROM Students cross join
       ct
) s join tch on tch.n = s.n;


NAME
NAME


Adam
Ethan

Bennet
Ethan

Elmer
Ethan

Jack
Kyle

Justin
Kyle

Louis
Leo

Noah
Leo

NAME	NAME
Adam	Ethan
Bennet	Ethan
Elmer	Ethan
Jack	Kyle
Justin	Kyle
Louis	Leo
Noah	Leo