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.

im am testing with oracle 11g r2
you could read this.. Click Here

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.