Hi,

If i have the following sql and it will returns more than 1 record.

select subjects from students
where name = 'oracle';

result:
science
maths
english

in this case, how do i concat it so that it will returns me science||maths||english in a single row? Any help pls? Thanks!