Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table one (dat varchar (4000), a varchar (4000), b varchar (4000), id varchar (4000), num varchar (4000), part varchar (4000))
INSERT into one (dat, a, b, id, num, part) values ('1234', 'aa', 'bb', 'None', '0', '0')
1 rows affected

INSERT into one (dat, a, b, id, num, part) values ('1235', 'ab', 'ba', '8b', '2', '2')
1 rows affected

INSERT into one (dat, a, b, id, num, part) values ('1238', 'ab', 'ba', '8b', '1', '2')
1 rows affected

select * from one


DAT
A
B
ID
NUM
PART


1234
aa
bb
None
0
0

1235
ab
ba
8b
2
2

1238
ab
ba
8b
1
2


create table two (dat varchar (4000), tst varchar (4000))
INSERT into two (dat, tst) values ('1234', 'ss tr rt')
1 rows affected

INSERT into two (dat, tst) values ('1235', 'ab rt')
1 rows affected

INSERT into two (dat, tst) values ('1238', 'er ty ui')
1 rows affected

select * from two


DAT
TST


1234
ss tr rt

1235
ab rt

1238
er ty ui


select 
    a, b, id, listagg (tst, ' ') within group (order by num asc) res
from one t1
join two t2 on t2.dat = t1.dat
group by a, b, id


A
B
ID
RES


aa
bb
None
ss tr rt

ab
ba
8b
er ty ui ab rt