Concat results

[mooks]

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! :D

[aph]

Use subQuery technique to get your desired result.

[mooks]

Thanks for the reply. Any examples please?
Thanks in advance!

[vbaskar]

Hi.

u wanted to transpose the rows right...there are people who did it using MULTIPLe decodes !! just search in the forum for TRANSPOSE..