with r0(typ,
cod) as
 (select 'Цвет1', 'АА'
    from dual
  union all
  select 'Цвет2', 'ББ'
    from dual
  union all
  select 'Цвет2', 'ВВ'
    from dual
  union all
  select 'Цвет3', 'ГГ'
    from dual
  union all
  select 'Цвет3', 'ДД'
    from dual
  union all
  select 'Цвет3', 'ЕЕ'
    from dual
  union all
  select 'Цвет3', 'ЖЖ'
    from dual),
r as
 (select distinct typ, cod from r0),
t0 as
 (select typ, count(1) as cnt_typ, row_number() over(order by typ) - 1 as typ_id from r group by typ),
t1 as
 (select typ, cnt_typ, typ_id, power(2, sum(log(2, cnt_typ)) over(order by typ_id)) as norm from t0),
t as
 (select typ, cnt_typ, typ_id, nvl(lag(norm) over(order by typ_id), 1) as norm from t1),
tc0 as
 (select r.typ, r.cod, row_number() over(partition by r.typ order by cod) - 1 as cod_id from r),
tc as
 (select tc0.typ, tc0.cod, cod_id, cod_id * norm as cod_val from tc0 join t on tc0.typ = t.typ),
tot(n,
typ,
cod,
typ_id,
chk) as
 (select tc.cod_val, tc.typ, tc.cod, t.typ_id, 1
    from t
    join tc
      on tc.typ = t.typ
   where typ_id = 0
  union all
  select tot.n + tc.cod_val,
         case l
           when 1 then
            tc.typ
           else
            tot.typ
         end,
         case l
           when 1 then
            tc.cod
           else
            tot.cod
         end,
         t.typ_id,
         case l
           when 2 then
            1
           else
            row_number() over(partition by l, tot.n + tc.cod_val order by 1)
         end
    from (select level as l from dual connect by level <= 2), tot
    join t
      on t.typ_id = tot.typ_id + 1
    join tc
      on tc.typ = t.typ
   where chk = 1)
select typ, cod
  from tot
 where typ_id = (select max(t.typ_id) from t)
   and chk = 1
 order by n, typ