SQL> ed
Wrote file afiedt.buf

  1  with t1 (tbn,n) as (
  2  select 1,'Аня' from dual union all
  3  select 2,'Саша' from dual union all
  4  select 3,'Таня' from dual union all
  5  select 4,'Ваня' from dual )
  6  ,t2 (tbn,sal) as (
  7  select 1,100 from dual union all
  8  select 2,200 from dual union all
  9  select 4,400 from dual union all
 10  select 1,101 from dual union all
 11  select 4,501 from dual )
 12  ,tt as(select t2.*,row_number() over (partition by tbn order by rownum) gr from t2)
 13* select * from tt partition by (gr) RIGHT OUTER JOIN t1 on (tt.tbn=t1.tbn)
SQL> /

        GR        TBN        SAL        TBN N
---------- ---------- ---------- ---------- ----
         1          1        100          1 Аня
         1          2        200          2 Саша
         1                                3 Таня
         1          4        400          4 Ваня
         2          1        101          1 Аня
         2                                2 Саша
         2                                3 Таня
         2          4        501          4 Ваня

8 rows selected.

SQL>