I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line.

select revertrsn  from LN08PENm where aano in(754,870,1136,1138,1139,1140)

the data coming in the row that I am retreiving is like this:

As per Mohammad Sulaiman's approval

by mail date 07/04/2009

And I want it to be in one line like this:

As per Mohammad Sulaiman's approval by mail date 07/04/2009

SELECT group_concat(revertrsn separator '  ') from LN08PENm  #for mysql
SELECT wm_concat(revertrsn)from LN08PENm                      # for oracle

Can this work on sql plus?

because it is showing me error.

what database are you using

how about this

select LISTAGG(column, ',')WITHIN GROUP (ORDER BY column) from tablename;

It is still showing error.

invalid identifier.

I am using oracle 10g, and I read that link, but it dont discuss (two lines in one cell).