select tablename,
ltrim(max(sys_connect_by_path(fieldname, ',')), ',') as fields
from (select tablename,
fieldname,
rnFirst,
lead(rnFirst) over(partition by tablename order by ordernumber asc) rnNext
from (select a.tablename,
a.fieldname,
a.ordernumber,
row_number() over(order by a.tablename, a.ordernumber asc) rnFirst
from vm_employeetablefields a where a.ismastertable=1 and a.employeeid=119 and a.rolemoduleid=230) tmpTable1) tmpTable2
start with rnFirst=1
connect by rnFirst = prior rnNext
group by tablename;