написал 2-ва запроса
select
substr(caccacc,-5) as "1",
substr (caccname,instr (caccname,':')+1)as "2"
from acc
where caccacc like '20202810%90%'and CACCNAME like '%№%'


и


select sum(mtrnsum)
from trn,acc where (dtrncreate between to_date('02.09.13','DD.MM.RR')
and to_date('09.09.13','DD.MM.RR'))
and (ctrnaccd like '20202%' ) and ctrnaccc=caccacc GROUP by ctrnaccc


Запросы выбирают по несколько строк.