select  fg  from (select 'ad12D23456ADZd&' fg from dual);

select  fg  from (select 'ad12D23456ADZd&' fg from dual);

ADad12341  - 1
ad12df331  - 0
Adweweww1  - 0
asA12fg4f  - 0
A1234D121  - 0
123erQq1A  - 1

ADad12341  - 1  
ad12df331  - 0   
Adweweww1  - 0
asA12fg4f  - 0
A1234D121  - 0
123erQq1A  - 1

ADad12341  - 1  
ad12df331  - 0    not valid because no upper character
Adweweww1  - 0    not valid because only one upper character
asA12fg4f  - 0    not valid because only one upper character
AaadaQwse  - 0    not valid because no digits
123erQq1A  - 1

SQL> With
  2    data as (
  3      select 'ADad12341' val from dual union all
  4      select 'ad12df331' val from dual union all
  5      select 'Adweweww1' val from dual union all
  6      select 'asA12fg4f' val from dual union all
  7      select 'AaadaQwse' val from dual union all
  8      select '123erQq1A' val from dual 
  9    )
 10  select val,
 11         case 
 12           when regexp_like(val, '[A-Z].*[A-Z]') and regexp_like(val, '\d.*\d')
 13             then 1
 14           else 0
 15         end res
 16  from data
 17  /
VAL              RES
--------- ----------
ADad12341          1
ad12df331          0
Adweweww1          0
asA12fg4f          0
AaadaQwse          0
123erQq1A          1

6 rows selected.