How to combine multiple rows into a single string in Oracle

This was the question in my mind that how to concatenate multiple rows into single column.

We can do with built-in function called ‘listagg’.
This is the example of the code

SELECT
    DEPTNO,
    LISTAGG(ENAME, ';') WITHIN GROUP(ORDER BY ENAME)
FROM
    SCOTT.EMP
GROUP BY
    DEPTNO
ORDER BY
    DEPTNO;