with t as (
select * from VD_DATA_COPY3 d3
union all
select c.*,null from V_COUNTRY_TEST3 c
)
,tt as (
   select t.* 
    ,row_number() over(order by country_name) rn
   from t)
,ttt as (
select tt.*
 ,last_value( ORDER_NUM ignore nulls) over(order by country_name 
  rows between unbounded preceding and current row ) l1
 ,first_value(order_num ignore nulls) over(order by country_name 
  rows between current row and unbounded following)  l2
 ,last_value( decode(ORDER_NUM,null,0+null,rn) ignore nulls) over(order by country_name 
  rows between unbounded preceding and current row ) r1
 ,first_value(decode(ORDER_NUM,null,0+null,rn) ignore nulls) over(order by country_name 
  rows between current row and unbounded following)  r2
from tt
)
select 
  country_name
 ,l1+(rn-r1)*(l2-l1)/(r2-r1) new_rn
from ttt
where order_num is null
order by 1
/

COUNTRY_NAME             NEW_RN
-------------------- ----------
АЛБАНИЯ                      32
АЛЖИР                        34
АМЕРИКАНСКОЕ САМОА           36
АНГИЛЬЯ                      38
АНТИГУА И БАРБУДА            55

SQL> with t as (
  2  select * from VD_DATA_COPY3 d3
  3  union all
  4  select c.*,null from V_COUNTRY_TEST3 c
  5  )
  6  ,tt as (
  7     select t.*
  8      ,row_number() over(order by country_name) rn
  9     from t)
 10  ,ttt as (
 11  select tt.*
 12   ,nvl(last_value( ORDER_NUM ignore nulls) over(order by country_name,ORDER_NUM
 13    rows between unbounded preceding and current row ),0) l1
 14   ,first_value(order_num ignore nulls) over(order by country_name,ORDER_NUM
 15    rows between current row and unbounded following)  l2
 16   ,nvl(last_value( decode(ORDER_NUM,null,0+null,rn) ignore nulls) over(order by country_name,ORDER_NUM
 17    rows between unbounded preceding and current row ),0) r1
 18   ,nvl(first_value(decode(ORDER_NUM,null,0+null,rn) ignore nulls) over(order by country_name,ORDER_NUM
 19    rows between current row and unbounded following),0)  r2
 20  from tt
 21  )
 22  select
 23    country_name
 24   ,l1+(rn-r1)*nvl2(l2,(nvl(l2,l1+10)-l1)/(r2-r1),10) new_rn
 25  from ttt
 26  where order_num is null
 27  order by 1
 28  /

COUNTRY_NAME             NEW_RN
-------------------- ----------
АА01                          1
АА02                          2
АА03                          3
АА04                          4
АА05                          5
АА06                          6
АА07                          7
АА08                          8
АА09                          9
АЛБАНИЯ                      32
АЛЖИР                        34
АМЕРИКАНСКОЕ САМОА           36
АНГИЛЬЯ                      38
АНТИГУА И БАРБУДА            55
Шамбула01                    90
Шамбула02                   100
Шамбула03                   110
Шамбула04                   120
Шамбула05                   130
Шамбула06                   140
Шамбула07                   150
Шамбула08                   160
Шамбула09                   170
Шамбула10                   180

24 rows selected.

  1  with VD_DATA_COPY3 as (select 'АВСТРАЛИЯ' name, 10 ORDER_NUM from dual union all
  2  select 'АВСТРИЯ',20 from dual union all
  3  select 'АЗЕРБАЙДЖАН',30 from dual union all
  4  select 'АНДОРРА',40 from dual union all
  5  select 'АНГОЛА',50 from dual union all
  6  select 'АРГЕНТИНА',60 from dual union all
  7  select 'АРМЕНИЯ',70 from dual union all
  8  select 'АЛБАНИЯ',30.04 from dual union all
  9  select 'АЛЖИР',30.05 from dual union all
 10  select 'АМЕРИКАНСКОЕ САМОА',30.06 from dual union all
 11  select 'АНГИЛЬЯ',30.07 from dual union all
 12  select 'АРУБА',80 from dual
 13  )
 14  , V_COUNTRY_TEST3(name) as (
 15  --select 'АВСТРАЛИЯ' name  from dual union all
 16  select 'АЛБАНИЯ1' name from dual union all
 17  --select 'АЛЖИР1' from dual union all
 18  --select 'АМЕРИКАНСКОЕ САМОА1' from dual union all
 19  --select 'АНГИЛЬЯ1' from dual union all
 20  select 'АЛБ07' from dual union all
 21  select 'АЛБ08' from dual union all
 22  select 'АЛБ09' from dual union all
 23  select 'АНТИГУА И БАРБУДА1' from dual)
 24  select v, country_name, nvl(num, lag(num,1,0) ignore nulls over (order by country_name)+(v/power(10,length(cnt))) ) la
 25  from (select rownum as v, country_name, num, count(*) over (order by null) cnt
 26          from (select NAME as country_name, ORDER_NUM as num
 27                  from VD_DATA_COPY3
 28               /*where (   TMPL_ROW_ID = 3222
 29                        OR TMPL_ROW_ID = 3223
 30                        OR TMPL_ROW_ID = 3224
 31                        OR TMPL_ROW_ID = 3225)
 32                       AND t055_id = 1952
 33                       AND ORDER_NUM not in (1340, 1350, 1360)*/
 34                union
 35                select NAME as contry_name, null
 36                  from V_COUNTRY_TEST3
 37                order by 1)
 38        ) t1
 39* order by la
SQL> /

         V COUNTRY_NAME               LA
---------- ------------------ ----------
         1 АВСТРАЛИЯ                  10
         2 АВСТРИЯ                    20
         3 АЗЕРБАЙДЖАН                30
         4 АЛБАНИЯ                 30,04
         9 АЛЖИР                   30,05
        10 АМЕРИКАНСКОЕ САМОА      30,06
        11 АНГИЛЬЯ                 30,07
         5 АЛБАНИЯ1                30,09
         6 АЛБ07                    30,1
         7 АЛБ08                   30,11
         8 АЛБ09                   30,12
        13 АНДОРРА                    40
        14 АНТИГУА И БАРБУДА1      40,14
        12 АНГОЛА                     50
        15 АРГЕНТИНА                  60
        16 АРМЕНИЯ                    70
        17 АРУБА                      80

17 rows selected.