You are trying to create a "comma separated list" from multiple rows.
The "best" way of doing this in Oracle depends on the version you have installed. As you have said "LISTAGG but its not fetching" I can only assume that the version you are using is prior to 11G Release 2.
On this
thread[
^] there are alternative several methods listed, I suggest starting with the accepted solution.