with s as (select dbms_random.string('a', 10) || to_char(trunc(dbms_random.value(100, 10000))) || 'АвторЧудак' str from dual)
select
str,
listagg(c, '') within group (order by decode(c, upper(c), 0, 1), translate(c, '~1234567890', '~') nulls last, c) as str1,
listagg(c, '') within group (order by decode(c, upper(c), 0, 1), decode(lower(c), upper(c), 1, 0), c)            as str2
from
   (select str, substr(str, level, 1) c
    from s
    connect by level <= length(str)
   )
group by str;

STR                            STR1                           STR2
------------------------------ ------------------------------ ------------------------------
YZXxumCObj6770АвторЧудак       COXYZАЧ0677bjmuxавдкорту       COXYZАЧ0677bjmuxавдкорту